Dbms_job.submit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dbms_job.submit

  1. #1
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74

    Dbms_job.submit

    Hi

    I'm trying to use the DBMS_JOB.SUMIT and i get an error.
    here is what I'm doing:

    I created a procedure called p2 and trying to call it in the what section of the submit

    variable jobno number;
    begin
    dbms_job.submit
    (
    jobno => :jobno,
    what => 'p2;',
    next_date => NEXT_DAY(TRUNC(SYSDATE), 'MONDAY') + 6/24
    );
    commit;
    END;
    /

    and i get the following>>

    Bind variable "JOBNO" not declared.

    Any help would be great.
    rajorcl

  2. #2
    Join Date
    Jun 2003
    Location
    australia
    Posts
    74
    dont worry i figured out what i was doing. Probably too much of drinks from last night stopped my brains thinking.

    kewl
    rajorcl

  3. #3
    Join Date
    Dec 2001
    Location
    UK
    Posts
    1,684
    Hi.

    It's helpful if you post the solution so others can benefit

    I believe the problem was you listed a parameter called "jobno" when the parameter is actually "job".

    Cheers

    Tim...
    Tim...
    OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
    OCA PL/SQL Developer
    Oracle ACE Director
    My website: www.oracle-base.com
    My blog: www.oracle-base.com/blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width