1 Reply Latest reply: May 2, 2013 1:04 PM by liaison1 RSS

    Got error in job execution, but the standalone procedure runs fine.

    liaison1
      I got error in job execution. But it runs fine as standalone procedure. Where could it be wrong?

      _>exec dbms_job.run(145373);
      BEGIN dbms_job.run(145373); END;

      *
      ERROR at line 1:
      ORA-12011: execution of 1 jobs failed
      ORA-06512: at "SYS.DBMS_IJOB", line 481
      ORA-06512: at "SYS.DBMS_JOB", line 275
      ORA-06512: at line 1

      I checked the alert log file

      ORA-06550: line 1, column 101:
      PLS-00103: Encountered the symbol "RPTIMPORT" when expecting one of the following:

      := . ( @ % ;
      Thu May 2 12:59:34 2013
      Errors in file /oracle/admin/PDAMLPR1/udump/pdamlpr11_ora_15574.trc:
      ORA-12012: error on auto execute of job 146925
      ORA-06550: line 1, column 133:
      PLS-00103: Encountered the symbol "" when expecting one of the following:

      := . ( @ % ;
      The symbol ";" was substituted for "" to continue.


      The trace file:

      *** ACTION NAME:() 2013-05-02 12:43:48.261
      *** MODULE NAME:(SQL*Plus) 2013-05-02 12:43:48.261
      *** SERVICE NAME:(SYS$USERS) 2013-05-02 12:43:48.261
      *** SESSION ID:(1811.10644) 2013-05-02 12:43:48.261
      *** 2013-05-02 12:43:48.261
      ORA-12012: error on auto execute of job 145373
      ORA-06550: line 1, column 133:
      PLS-00103: Encountered the symbol "" when expecting one of the following:
      := . ( @ % ;
      The symbol ";" was substituted for "" to continue.
      *** ACTION NAME:(********* Schedule Job: Report C) 2013-05-02 12:47:58.178
      *** MODULE NAME:(PATIENT_REMEDIATE_JOB) 2013-05-02 12:47:58.178
      *** 2013-05-02 12:47:58.178
      ORA-12012: error on auto execute of job 145373
      ORA-06550: line 1, column 133:
      PLS-00103: Encountered the symbol "" when expecting one of the following:
      := . ( @ % ;
      The symbol ";" was substituted for "" to continue.
      *** 2013-05-02 12:52:43.409
      ORA-12012: error on auto execute of job 146924
      ORA-06550: line 1, column 101:
      PLS-00103: Encountered the symbol "RPTIMPORT" when expecting one of the following:
      := . ( @ % ;
      *** 2013-05-02 12:59:34.651
      ORA-12012: error on auto execute of job 146925
      ORA-06550: line 1, column 133:
      PLS-00103: Encountered the symbol "" when expecting one of the following:
      := . ( @ % ;
      The symbol ";" was substituted for "" to continue.
      ~
      ~
      The job was created as the following with 30 min interval:

      The job number: 145373

      DECLARE
      X NUMBER;
      BEGIN
      SYS.DBMS_JOB.SUBMIT
      ( job => X
      ,what => 'RPTIMPORT.pr_exec_pop_ddl21_data_irt'
      ,next_date => to_date(sysdate)
      ,interval => '/*30:Mins*/ sysdate + 30/(60*24)'
      ,no_parse => TRUE
      );
      SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
      END;
      /


      Thanks for help!