RE: Asynchronus PL/SQL - Webservices Call

To answer your question on submitting an Oracle Job within a trigger:  

The job won't run until you commit. If you rollback then the job submission is rolled back also. This is very useful. I have seen it used for sending email from within a trigger. The email will only get sent if the transaction commits.
Jim

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subbiah, Nagarajan Sent: Thursday, September 29, 2005 9:29 AM To: 'oracle-l_at_freelists.org'
Subject: Asynchronus PL/SQL - Webservices Call

Hi,  

We have a requirement to call a PL/SQL procedure in asynchronous mode with in the transaction. The Procedure1 is a trigger of a table which calls a web service with in the procedure Procedure2 using 'utl_http'.  

What are the options to call the Procedure2 as not part of the transaction OR is there any way to call the 'utl_http' call asynchronously?  

There are few options we consider:  

• One way handle this is as part of the application and storing the value in a table and schedule a procedure in the oracle job to handle this.
• Other way is to submit a job in the oracle jobs with in a trigger to call the procedure 2. But The question is: How does oracle handle the job which is submitted the part of the trigger? Will that be considered as part of the transaction?
• Third way is to use the Oracle streams and using queues the same mechanism of Oracle jobs.

If there any simple way to achieve this.  

Thanks in Advance.  

Raja.

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