Asynchronus PL/SQL - Webservices Call
- From: "Subbiah, Nagarajan" <Nagarajan.Subbiah@xxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Sep 2005 12:29:09 -0400
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: