| 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.
Hi !
The problem with this solution is that the row, inserted into my table, will
be committed (i.e. seen by other users) only after the completion of the
stored procedure called by the trigger.
Thanks a lot !
-----Original Message-----
Sent: Thursday, November 28, 2002 9:09 PM
To: Multiple recipients of list ORACLE-L
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).
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 Sun Dec 01 2002 - 08:23:39 CST
 |
 |