Get the sql query in oracle trigger Hi,
I am wondering if there is a way that you can get the SQL query string
that triggers the Oracle Trigger.
what I want to do is to write a INSERT/UPDATE trigger for all the
tables, and in the trigger i will call a java function that will do
some validation on the table name, columns and its data of course.
Or is there a better way to achieve this?
another option I have is to use JPublisher; however, i have no idea
what it really does.
so, anyway has a thought?
thanks~ |