Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to find current value of bind variables

Re: How to find current value of bind variables

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 1 Sep 2005 20:50:06 +0100
Message-ID: <bf4638050901125039c12532@mail.gmail.com>


You might examine V$SQL_BIND_DATA.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist



On 9/1/05, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:

>
> Does anyone know if there is a way to find out what values are in effect
> for the bind variables of a currently running query?
> I know how to find bind variable values with a trace, but that requires
> you to start a trace prior to the parsing of the query and it's too late for
> that.
> Thanks,
> Brandon
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 01 2005 - 15:39:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US