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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to gather bind params in SQL?

Re: How to gather bind params in SQL?

From: Victor <mvici_at_yandex.ru>
Date: 10 Aug 2004 01:01:40 -0700
Message-ID: <2c447de6.0408100001.b8ccc2c@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? Received on Tue Aug 10 2004 - 03:01:40 CDT

Original text of this message

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