Shouldn't this happen AFTER the data got committed??
consider the scenario ... you add a row, and _assume_ your code works right and
it spits out a text file. After the text file is complete, your transaction
rolls back for any reason ... aren't you dealing with inconsistent
data??
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot
com
All Views expressed in this email
are strictly personal.
select
standard_disclaimer from company_requirements;
QOTD: Any clod can have facts, having an opinion is an
art !
Hi all,
Scenario:
We have an
issue with PL/SQL Trigger involving another PL/SQL Procedure & a Java
stored procedure.
The trigger will be
invoked when ever there is any transaction occurs on a particular table. This
calls a PL/SQL Procedure that inturn invokes a Java stored procedure.
The Java stored procedure will reads
the data from the table and write it to a text file.
Issue:
The issue we are facing is that the Java stored procedure is unable to
get the latest changes made to the table, which invoked the trigger.
Example:
We have 4 records in the table. If we insert another
record, then it inturns fires the trigger and that calls the procedure and
Java stored procedure.
The Java stored
procedure was able to select only the 4 records but not the 5 record which has
fired the trigger.
The event of
the trigger is mentioned as "after insert/delete/update for each row".
Attached the code for your
reference.
Please let me know if
anybody has a solution for this issue.
Thanks and Regards,
R.
Rangadoure
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Feb 25 2004 - 08:13:41 CST
