Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to gather bind params in SQL?
"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? Received on Tue Aug 10 2004 - 03:01:40 CDT