On May 30, 9:35 pm, zigzag..._at_yahoo.com wrote:
> On May 30, 11:31 am, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > zigzag..._at_yahoo.com wrote:
> > > I am supporting a ERP application, do not have access to source code.
> > > crsor_sharing is set to force so when I look in v$sql etc it shows me
> > > the statement with various bind varaiables. Is there any way to find
> > > the original query before Oracle replaced literals by bind variables.
>
> > > Thanks.
>
> > select view_name from dba_views
> > where view_name like '%BIND%';
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org
>
> I did look into these views, I still did not see the sql satements. I
> am on Oracle 9.2.0.6 on Windows Server.
> Really appareciate if you can provide more information.- Hide quoted text -
>
> - Show quoted text -
I do see v$sql_bind_data which has a column value which probably
should give value of bind variable. Bust since this values is blank,
not sure what the column represents.
Received on Wed May 30 2007 - 20:57:48 CDT
