Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_JOB.SUBMIT
DBMS_JOB.SUBMIT [message #230729] Thu, 12 April 2007 12:14 Go to next message
srinivas.k2005
Messages: 340
Registered: August 2006
Senior Member
Hi,

I executed the following procedure, it ran successfully.

DECLARE
jobno NUMBER;
BEGIN
DBMS_JOB.SUBMIT
(job => jobno
,what => 'begin pr_test; end;'
,next_date => SYSDATE+4.95/12
,interval => 'SYSDATE+1/24');
COMMIT;
END;
/

in the procedure pr_test,i have just given one line statement.
DBMS_output.put_line('hello');

4/12/2007 11:05:46 PM ----it should execute at this time.
But i am not getting any output.

Thanks,
Srinivas
Re: DBMS_JOB.SUBMIT [message #230730 is a reply to message #230729] Thu, 12 April 2007 12:18 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Where do you think it could be output?
2/ dbms_output.put_line just fill a buffer, you have to take it out to do what you want, for instance display it somewhere.

Regards
Michel
Previous Topic: inline query n lookup tables
Next Topic: randomness sdo_buffer & nearest neighbour
Goto Forum:
  


Current Time: Wed Dec 07 18:31:37 CST 2016

Total time taken to generate the page: 0.07054 seconds