Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error while runing dbms_job.isubmit

519523Aug 12 2006 — edited Aug 13 2006
i created a procedure proc1 in user scott which inserts a sequence of numbers into the table called 'ss' .

create or replace procedure proc1(a in number) is
begin
insert into ss values(seq1.nextval);
end;


Later i tried to run the dbms_job .submit from the sys user in the following way:

variable jobno number;

BEGIN
DBMS_JOB.isubmit (
:jobno,
what => 'scott.proc1(3);',
next_date => SYSDATE,
interval => 'SYSDATE + 1/144 /* 1 Hour */');

COMMIT;
END;
/

I am getting the error :

BEGIN
*
ERROR at line 1:
ORA-01407: cannot update ("SYS"."JOB$"."JOB") to NULL
ORA-06512: at "SYS.DBMS_JOB", line 97
ORA-06512: at line 2


can anybody help me.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 10 2006
Added on Aug 12 2006
4 comments
588 views