Re: Q: Detecting values of bind vars

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 04 Apr 2001 16:28:42 +0200
Message-ID: <hpbmcto1temudc0i4rt6k5b07g172okpv3@4ax.com>

On Wed, 4 Apr 2001 11:26:56 +0200, "Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote:

>Hi folks
>
>(8.1.6)
>
>I just came across the views v$sql_bind_data and v$sql_bind_metadata. Can
>these be used to determine the values of the bind vars in whatever SQL a
>user is currently executing? If so, how?
>
>Regards,
>Ivan Bajon, ocp
>

Visit www.ixora.com.au and download the toolkit located . You need to set an event for this and the info will end up in your trace file. From the top of my head it is
alter session set event="10046 trace name level 12 context forever"

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Apr 04 2001 - 09:28:42 CDT