Re: Capture Errorred SQL Statement

On 10-Feb-99 17:35:32 gcwong wrote:

>Is there any Oracle tables which captures all SQL statements even if
>the statement fails the parsing or binding? I know that the
>sys.v_$sqlarea holds sql statements which have executed.

>I'm trying to debug a third party package which we use and I a partial
>statement on their dialog box but can't see the rest - I'm trying to
>load a table with data and I get an error which does not make sense.

You could try setting sql_trace=true for your session. In the trace file you can see the failed SQL statement. (At least if the parsing failed. I don't have experience tracing failed bindings.) To improve readability you should pass the trace file through tkprof.

Hope that helps,
Lothar

--

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |