RE: Asynchronus PL/SQL - Webservices Call
- From: "Kennedy, Jim" <jim_kennedy@xxxxxxxxxx>
- To: <Nagarajan.Subbiah@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 09:54:17 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subbiah, Nagarajan
Sent: Thursday, September 29, 2005 9:29 AM
To: 'oracle-l@xxxxxxxxxxxxx'
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.
Other related posts:
