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~ Received on Wed Mar 29 2006 - 16:46:55 CST