DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2000

    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

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

  2. #2
    Join Date
    Aug 2003


    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');


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.