Re: Identify SQL that generated and ORA-00922

Hi Erik, if you execute the following on your system

   alter system set events '922 trace name errorstack level 1'; then any session that gets ORA-09922 will generate a trace-file in the user-dump directory, and there you will see the exact sql that caused the error.

Do an

   alter system set events '922 trace name errorstack off'; to disable this trace.

Regards, Hans Henrik Krohn

Erik Dantes <erik.dantes_at_wmich.edu> wrote in message news:<3C1E5471.708D297E_at_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 Wed Dec 19 2001 - 06:24:46 CST