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 -> Identify SQL that generated and ORA-00922

Identify SQL that generated and ORA-00922

From: Erik Dantes <erik.dantes_at_wmich.edu>
Date: Mon, 17 Dec 2001 15:24:17 -0500
Message-ID: <3C1E5471.708D297E@wmich.edu>


I have a third party application which is running various sql statement during an upgrade to the tables they provided. At one point, their app returns the ORA-00922 error and does not go any further in the upgrade. They have me doing all sorts of silly things because (I don't think) they know where in the code it is dying. Is there a way that I can find the SQL statement that is causing the error so that I can start to figure out what is going on? I have OEM 2.0.4 and tried to use TopSessions to help give me an idea, but nothing jumped out. Running Oracle 8.1.5. This is running in our test instance, so I can start and stop it if needed.

Erik Dantes Received on Mon Dec 17 2001 - 14:24:17 CST

Original text of this message

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