does dbms_job.submit work?

From: BM Lam <1116-530_at_online.de>
Date: Wed, 30 Jun 1999 23:31:32 +0200
Message-ID: <377A8CB4.6E9C8A5@online.de>

I wrote a procedure as follows:

create or replace procedure guguck as
begin

	insert into debug_log
		(text, timestamp)
		values
		'this record is inserted by guguck', sysdate;
	commit;

end;

The procedure gets compiled just fine (I have created table debug_log prior to that). Then
I entered:

declare

        v_JobNo binary_integer;
begin

        dbms_job.submit(v_jobNo, 'guguck;', sysdate+1/(24*60)); end;

The message "PL/SQL procedure successfully completed." is returned. Also user_jobs showed a new job scheduled for the next minute.

But when I checked debug_log after the scheduled time (several times) I never found the record I mean to insert in procedure GUGUCK.

I tested this on Oracle7 and 8. Neither worked.

Any hint/explanation will be greatly appreciated.

Received on Wed Jun 30 1999 - 16:31:32 CDT