| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: a PL/SQL design question.
Andrey
Please forgive me if this sounds like a theoretical solution, since I don't
have the time to try it out relevant to your situation.
But what about using the trigger to call a procedure which is an autonomous
transaction ? You do this by placing the following anywhere in the declare
section of the SP:
pragma AUTONOMOUS_TRANSACTION
This will allow the operation to take place and commit, completely independent of the master transaction.
My 2 cents' worth. HTH.
Ferenc Mantfeld
-----Original Message-----
From: Andrey Bronfin [SMTP:andreyb_at_elrontelesoft.com] Sent: Friday, November 29, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Subject: a PL/SQL design question.
Dear gurus!
I'm looking for a solution to the following problem:
I need a way to run a certain stored procedure as soon as a record is
inserted into a certain table.
A trigger is not feasible for this, since I do not want the execution of
the
procedure to be a part of the transaction that inserts a row into the
table.
I want the insertion to be visible to all the users (i.e. committed) as
soon
as the insertion is done, and then, as a separate transaction of its own,
to
run the stored procedure.
Suggestions , please ?
Thanks a lot !
<< File: ATT00003.html >>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: mantfield
INET: mantfield_at_connexus.net.au
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Nov 28 2002 - 13:09:00 CST
 |
 |