Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to gather bind params in SQL?
mvici_at_yandex.ru (Victor) wrote in message news:<2c447de6.0408100001.b8ccc2c_at_posting.google.com>...
> "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?
Can you be more specific on what you need by giving an example? Usually people ask for bind variable values. That can be provided by the variable_value procedure in dbms_sql. Do you want the name like varname in the following sqlplus command?
SQL> variable varname number
SQL> print varname
Yong Huang Received on Tue Aug 10 2004 - 10:51:06 CDT