Frank Tropschuh wrote:
>
> I cannot submit a new job -- any suggestions?
.....
> SQL> VARIABLE ANALYZE_ID NUMBER;
> SQL> EXECUTE DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0)', SYSDATE,
> 'SYSDATE + 1');
> begin DBMS_JOB.submit(:ANALYZE_ID, 'PG_JOBS.ANALYZE(0)', 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:
> := . ( % ;
> ; was inserted before "END" to continue.
> ORA-06512: at "SYS.DBMS_JOB", line 67
> ORA-06512: at "SYS.DBMS_JOB", line 117
> ORA-06512: at line 1
>
> Thanks,
> trf
>
Yes, I know that error message well. The problem is that you must
include the trailing ';' in the statement you want to submit. ORACLE
parses the string you pass and analyzes it. See the ORACLE7 Server
Administrator's guide, Managing Job Queues, page 7 - 7. Note also the
optional 'NO_PARSE' flag in the DBMS_JOB.SUBMIT call.
--
Christoph Ganz
IDS Prof. Scheer GmbH
Altenkesseler Str. 17
D-66115 Saarbruecken
Tel +49 681 9921 660 Fax 501
Received on Tue Jun 24 1997 - 00:00:00 CDT
