Home » SQL & PL/SQL » SQL & PL/SQL » How to call (10g)
How to call [message #448625] Wed, 24 March 2010 07:01 Go to next message
eight8ball@gmail.com
Messages: 20
Registered: February 2010
Junior Member
Hi.

Can someone tell me how to make a call to a proc and immediately return without waiting for the called proc to end.

Nothing I try seems to do the trick...The calling program always has to wait...

Help??

Joe
Re: How to call [message #448626 is a reply to message #448625] Wed, 24 March 2010 07:04 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
use dbms_job
Re: How to call [message #448628 is a reply to message #448625] Wed, 24 March 2010 07:05 Go to previous messageGo to next message
eight8ball@gmail.com
Messages: 20
Registered: February 2010
Junior Member
Tried that, it doesnt work.
Re: How to call [message #448629 is a reply to message #448628] Wed, 24 March 2010 07:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You did it wrong.

Regards
Michel
Re: How to call [message #448630 is a reply to message #448629] Wed, 24 March 2010 07:07 Go to previous messageGo to next message
eight8ball@gmail.com
Messages: 20
Registered: February 2010
Junior Member
got an example of how to then?
Re: How to call [message #448632 is a reply to message #448625] Wed, 24 March 2010 07:13 Go to previous messageGo to next message
cookiemonster
Messages: 12404
Registered: September 2008
Location: Rainy Manchester
Senior Member
There's plenty of examples in the documentation.
You do need to do a commit after creating the job for it to run.
Re: How to call [message #448642 is a reply to message #448630] Wed, 24 March 2010 07:47 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_JOB.


Regards
Michel
Tell me and I'll forget; show me and I may remember; involve me and I'll understand
Previous Topic: Sorting VARCHAR2 field
Next Topic: Numbering on break
Goto Forum:
  


Current Time: Tue Dec 06 00:23:03 CST 2016

Total time taken to generate the page: 0.06599 seconds