Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DBMS_JOB not recognised
My fault, I had indeed missed 'EXECUTE' out of the statement as I was running it in SQL Plus.
"andrew_webby at hotmail" <spam_at_no.thanks.com> wrote in message
news:991391533.23054.0.nnrp-13.c30bdde2_at_news.demon.co.uk...
> Who are you connected as? And did you use 'execute'? Do you have
permissions
> to use it if non-sys?
>
> connect sys/change_on_install
> grant execute on dbms_job to normal_user;
> connect normal_user/pw
> execute dbms_job...etc
>
> "Ian Carrick" <ian_at_rombus.co.uk> wrote in message
> news:991382779.9980.0.nnrp-07.c2de47d8_at_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 - 09:25:00 CDT