Re: Q: how to find the value of bind varaiable

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 23 Apr 2002 03:45:14 -0700
Message-ID: <a20d28ee.0204230245.658d34d1@posting.google.com>

tedchyn_at_yahoo.com (Ted Chyn) wrote in message news:<44a19320.0204222117.104d90a2_at_posting.google.com>...
> Sir,
> How to find the value of bind variable in memory associated with a session
> without using sql trace ?
>
> thnx ted chyn

No version of course.
In 8i various v$ views exists. From the top of my head I only remember v$sql_bind_meta_data, but there are more, all with the word 'bind' in it.
The dict view would typically contain all of them

and oh yes
'Stop calling me SIR Marcie'
Peppermint Patty in Charles Schulz long-running comic Peanuts

Regards

Sybrand Bakker
Senior Oracle DBA Received on Tue Apr 23 2002 - 05:45:14 CDT