dbms_job.submit giving me error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbms_job.submit giving me error

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    46

    dbms_job.submit giving me error

    I am trying to set up a job using dbms_job but I am getting an error I can't figure out. The dbms_job package is valid.


    SQL>exec dbms_job.submit(:n1, 'LMT_Gather_Ts_Data', sysdate, 'sysdate + 1');
    BEGIN dbms_job.submit(:n1, 'LMT_Gather_Ts_Data', sysdate, 'sysdate + 1'); END;

    *
    ERROR at line 1:
    ORA-06550: line 1, column 112:
    PLS-00103: Encountered the symbol "END" when expecting one of the following:
    := . ( @ % ;
    The symbol ";" was substituted for "END" to continue.
    ORA-06512: at "SYS.DBMS_JOB", line 79
    ORA-06512: at "SYS.DBMS_JOB", line 131
    ORA-06512: at line 1

    Since dbms_job is a wrapped package, I'm unable to see the actual code. The version of the Database is 8.1.7.4.0

    Any Suggestions?
    Last edited by gram2000; 08-12-2003 at 12:01 PM.

  2. #2
    Join Date
    Aug 2003
    Posts
    11

    dbms_job

    Hi gram2000,

    You need to add a semi colon after the call to the procedure in the dbms_job package.

    Try this
    exec dbms_job.submit(:n1, 'LMT_Gather_Ts_Data;', sysdate, 'sysdate + 1');

    Cheers
    Slash

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