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~....

I'm with EdStevens ... what is the result you wish to achieve. This process seems to be the worst possible way to accomplish most anything.

Where is the SQL coming from you wish to capture? In what version of Oracle?
Why a Java function rather than PL/SQL?
Have you looked at Advanced Queuing and JMS?

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)