Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Q: Can I find out what the last executed SQL statment was.

Q: Can I find out what the last executed SQL statment was.

From: Paul Smith <syd_at_compuserve.comz>
Date: Mon, 27 Jul 1998 13:01:19 GMT
Message-ID: <35bc7a18.16666730@news.compuserve.com>


I would like to put the SQL string of the last executed statement into an error table if it fails, but to do this I need to know what the statement was - is there an internal table/view I can interrogate for each session to find this?

--
Paul Smith
Technical Manager, SDR Systems Ltd
Please change Compuserve.comz to Compuserve.com to respond via Email Received on Mon Jul 27 1998 - 08:01:19 CDT

Original text of this message

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