Re: Capture Errorred SQL Statement

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Thu, 11 Feb 1999 23:39:04 GMT
Message-ID: <sSJw2.5445$cQ5.2826@nnrp2.clara.net>

gcwong_at_interlog.com <gcwong_at_interlog.com> wrote in message <79scgj$oo4$1_at_nnrp1.dejanews.com>...
> Is there any Oracle tables which captures all SQL statements even if the
> statement fails the parsing or binding?

If you switch on SQL tracing, all SQL statements will be logged to .trc files (outside the database) even if they've got parse or binding errors.

If you can't issue an 'ALTER SESSION SET SQL_TRACE TRUE;' statement in the application you want to monitor, try using the procedure DBMS_UTIL.SET_SQL_TRACE_IN_SESSION. As a last resort, you could always switch on tracing database-wide using init.ora parameter: sql_trace = true.

Dave.
--
Remove "nospam" from my address to reply by email Received on Thu Feb 11 1999 - 17:39:04 CST