View Single Post

   
  #1 (permalink)  
Old 02-25-2008, 04:23 AM
eric.h.lin@gmail.com
 
Posts: n/a
Default 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~

Reply With Quote