Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> DBMS_JOB not recognised
Using Oracle8i and I'm running the following command:-
dbms_job.submit(:j, 'USP_EXPIREBASKETS(SYSDATE);', SYSDATE, 'sysdate + (60/(24*60*60))');
I get this error message back:-
SP2-0734: unknown command beginning "dbms_job.s..." - rest of line ignored.
What should I be checking? The dbms_job package is installed under SYS and I have not made any amendments to it since installation.
Thanks in advance. Received on Fri Jun 01 2001 - 03:08:16 CDT