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.
Received on Wed May 30 2007 - 20:35:20 CDT
