Re: How to catch the SQL statement

From: Reid Lai <reidlai_at_hk.super.net>
Date: Sat, 24 Oct 1998 12:32:24 +0800
Message-ID: <36315858.865AE456@hk.super.net>

You can find out the current session id by DBMS_SESSION package within your trigger. And use this id to query the sql_address column and then search V$SQLAREA with address column by this value. Hope this can help you.

agganesh_at_my-dejanews.com wrote:

> Is there any way to catch the sql statement which fires a trigger?
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--
Best Regards,

Reid Lai <reidlai_at_hk.super.net>
Certified Oracle 7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Oct 23 1998 - 23:32:24 CDT