On May 30, 9:57 pm, zigzag..._at_yahoo.com wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Mtealink doc 1068973.6 provides what I was looking for. Thanks for the
responses.
Received on Wed May 30 2007 - 21:18:11 CDT
