Re: Get the sql query in oracle trigger

eric.h.lin_at_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. Received on Thu Mar 30 2006 - 12:25:39 CST