Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Asynchronous calls from within Oracle?

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US