Re: DBMS_JOB not recognised

From: andrew_webby at hotmail <spam_at_no.thanks.com>
Date: Fri, 1 Jun 2001 11:31:04 +0100
Message-ID: <991391533.23054.0.nnrp-13.c30bdde2@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 - 05:31:04 CDT