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:
