| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Identify SQL that generated and ORA-00922
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
![]() |
![]() |