Re: Literal or bind variable

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Thu, 28 Feb 2002 22:07:00 GMT
Message-ID: <3C7EAA09.1D139455@ci.seattle.wa.us>

Look in v_$open_cursor and see whether the vars are showing up preceeded by a colon.

Daniel Morgan

Connor McDonald wrote:

> Gopal wrote:
> >
> > Hi All,
> >
> > Does any one have script to find out whether the statements are
> > using literals or bind variables for the same statements ? Please
> > help.
> >
> > Thanks,
> > regards
>
> Search asktom.oracle.com for "_wo_"
>
> hth
> connor
> --
> ==============================
> Connor McDonald
>
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue..."
Received on Thu Feb 28 2002 - 16:07:00 CST