Re: Some users unable to submit via DBMS_JOB

I'm not 100% sure but you may have to put your pl/sql in a procedure/function and call that from dbms_job.

Also, you may not need quotes if using sysdate.

e.g

begin

   dbms_job(1,'procedure',sysdate, sysdate + 1); end;

Mark

gregrahn_at_my-deja.com wrote in message <7j3sdv$q0t$1_at_nnrp1.deja.com>...
>Here is my problem.
>
>Some users are able to sumbit a job via DBMS_JOB
>and others are not. I noticed that all the
>accounts created after a point in time
>( the created col from dba_users )
>are unable to submit a job to the queue.
>
>The error returned is such:
>
>SQL> var jobno NUMBER
>SQL> BEGIN
> 2 DBMS_JOB.SUBMIT(:jobno,'BEGIN NULL;END;',SYSDATE,'SYSDATE+1');
> 3 END;
> 4 /
>BEGIN
>*
>ERROR at line 1:
>ORA-01403: no data found
>ORA-06512: at "SYS.DBMS_JOB", line 126
>ORA-06512: at line 2
>
>
>I did some mass account deletions and creations
>and am wondering if something got cheesed up in
>the internal tables.
>
>Any help would be appreciated!!
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 03 1999 - 08:25:02 CDT