| get sql_text within trigger [message #370040] |
Mon, 04 December 2000 13:05 |
Jasmine
Messages: 23
Registered: December 2000
|
Junior Member |
|
|
Now I'm meeting a trouble and really need some help. My task is : keep track of
changes of oracle db tables and write into a dbm file only the exact sql statement that did the change.
I know how to get the old and new values by new.column_name and old.column_name. But I just need the original dml statement that fire my trigger. I can use "select sql_text from v$open_cursor" get some sql statement but not suitable for this sutiation.
Can any body here tell me if it is possible for capturing the whole sql text in my trigger script? Thank you in advance and any help will be appreciated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
