View Single Post

   
  #7 (permalink)  
Old 02-25-2008, 04:24 AM
EdStevens
 
Posts: n/a
Default Re: Get the sql query in oracle trigger


eric.h.lin@gmail.com wrote:
> Hi all,
>
> The reason I wannna do this is because I want to capture the direct sql
> query (using trigger) and send it to a java function. Then parse the
> sql query and contruct a web service call according to the table and
> column it is trying to insert or update.
>
> maybe there is a better solution for this, I don't know~....


You're still just describing a process you envision using. Tell us
what it is you are really trying to accomplish. What is the business
problem you are trying to solve -- not the intermediate technical
problem.

Reply With Quote