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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
