Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> DBMS_JOB not recognised

DBMS_JOB not recognised

From: Ian Carrick <ian_at_rombus.co.uk>
Date: Fri, 1 Jun 2001 09:08:16 +0100
Message-ID: <991382779.9980.0.nnrp-07.c2de47d8@news.demon.co.uk>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US