Re: How can I TRACE my dynamic SQL sent to ORACLE SERVER?

Martin said -
>Write the same string you send to the server to either a file, or a
>temporary table is what I do.
>Then you can copy the string to SQL Plus and see what's wrong.
>

Thanks Martin , but how can I write the query statement to a file? I'm using Dynamic SQL , and can I see which statement is made in Run-Time?? I want to use different user name for TABLE A, and It looks like SELECT .., .... ,...
FROM :v1.A
with host variable v1...
Is it right to use Dynamic SQL Type 3 for this purpose?? and more about TRACE?? Received on Fri Nov 28 1997 - 00:00:00 CST