RE: Asynchronous calls from within Oracle?
- From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
- To: "'Nagarajan.Subbiah@xxxxxxxx'" <Nagarajan.Subbiah@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Jun 2006 19:46:25 +0100
One way to do it is to submit the execution of Procedure B via DBMS_JOB (or DBMS_SCHEDULER in 10g). Note that you must COMMIT the submission of the job for it to run. Paul Baumgartel CREDIT SUISSE Information Technology DBA & Admin - NY, KIGA 1 11 Madison Avenue New York, NY 10010 USA Phone 212.538.1143 paul.baumgartel@xxxxxxxxxxxxxxxxx www.credit-suisse.com -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Subbiah, Nagarajan Sent: Wednesday, June 21, 2006 12:23 PM To: oracle-l@xxxxxxxxxxxxx Subject: Asynchronous calls from within Oracle? Hi List, If there is any way for an Oracle Package to make an Asynchronous call from within Procedure A to another Procedure B where Procedure A can finish and return regardless of Procedure B's status ? Thanks in Advance. Raja. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================
Other related posts:
- » Asynchronous calls from within Oracle?
- » RE: Asynchronous calls from within Oracle?