Re: How to gather bind params in SQL?

Victor wrote:
>
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<Xns9540B8BB42115SunnySD_at_68.6.19.6>...
> > mvici_at_yandex.ru (Victor) wrote in
> > news:2c447de6.0408090906.12466ac1_at_posting.google.com:
> >
> > > Oracle Server 9.2.0.5
> > > How can I gather param names (bind variables) in dynamic SQL (or PL/SQL)
> > > string?
> > > It seems that dbms_sql wouldn't help resolve the problem.
> > > Manual SQL string parsing is not acceptable...
> > >
> >
> > SQL_TRACE (event 10046) & level=12
>
> well, is it possible to get the bind variables' names from the trace
> info in PL/SQL environment? and how?

I can't remember whether this is v10 or v9, but you could look at:

V$SQL_BIND_CAPTURE
V$SQL_BIND_DATA
V$SQL_BIND_METADATA

hth

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------