RE: Asynchronous calls from within Oracle?

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Wed, 21 Jun 2006 19:46:25 +0100
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC0F40E38F@ENYC11P32005.corpny.csfb.com>

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_at_credit-suisse.com
www.credit-suisse.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Subbiah, Nagarajan Sent: Wednesday, June 21, 2006 12:23 PM
To: oracle-l_at_freelists.org
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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jun 21 2006 - 13:46:25 CDT