Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the current/last run SQL statement into a string variable?

Re: How to get the current/last run SQL statement into a string variable?

From: dombrooks <dombrooks_at_hotmail.com>
Date: 7 Apr 2007 00:00:19 -0700
Message-ID: <1175929219.837660.212990@e65g2000hsc.googlegroups.com>

Depending on your version, there is a stack of error messages and sql available using things like ora_server_error_msg and ora_sql_txt. Sometimes used, for example, in an ON SERVERERROR trigger.

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#i1006519 Received on Sat Apr 07 2007 - 02:00:19 CDT

This message: [ Message body ]
Next message: Mladen Gogala: "Re: Another oracle resource goes down the drain"
Previous message: Mladen Gogala: "Re: Another oracle resource goes down the drain"
In reply to: JB: "How to get the current/last run SQL statement into a string variable?"
Next in thread: Niall Litchfield: "Re: How to get the current/last run SQL statement into a string variable?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US