Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Can i get current SQL statement in a trigger?
We are migrating from a mainframe based database to Oracle 7.3 running under AIX. Unfortunately, we need to keep both around during the transition. What i'd like to do is create a trigger on each table that executes after an insert, update, or delete. I want the trigger to call a C function (using PLEX-this part already works) and pass the SQL statement which caused the update, insert, or delete to occur. The server will in turn pass the SQL statement onto our mainframe database so it too can perform the change.
How can I grab the SQL statement which caused the trigger to fire? Is this in a table somewhere?
Thanks.
ltost_at_systemautomation.com
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Fri Apr 18 1997 - 00:00:00 CDT