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

From: Tanasescu iosif <nospam_iositan_at_sprint.ca>
Date: 1997/11/30
Message-ID: <01bcfd47$4512da20$0b1867d1@iositan>#1/1

Why

alter session set sql_trace=TRUE
..
..
alter session set sql_trace=FALSE,

and then look in your TRACE directory.., or even better, run TKPROF against the trc file.

Cho YongHo <hauhau_at_www.kdn.com> wrote in article <65m8ev$pjm$1_at_n1.HanQ.net>...
> I'm using Dynamic Type 3 written ProC..
>
> when I execute it , I've gotten the ERROR of 'ORA-00933: SQL command not
> properly ended'..
> and I wish to see exactly which statement is sent to my SERVER..
>
> Is there any way or tool I can do this with??
>
>
>
Received on Sun Nov 30 1997 - 00:00:00 CST