Re: ORA-04093
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Mon, 25 Jun 2012 12:50:48 -0500 (CDT)
Message-ID: <130277f44a16e23fa4a3f1ae1a2f364f.squirrel_at_society.servebeer.com>
Hey Bob,
Date: Mon, 25 Jun 2012 12:50:48 -0500 (CDT)
Message-ID: <130277f44a16e23fa4a3f1ae1a2f364f.squirrel_at_society.servebeer.com>
Hey Bob,
> I am getting an upexpected error out of a function. The error is
> occurring on the statement at line 412. It is not actually the
> statement that is abending but the before insert trigger on the table
> LGTY_SAVE_TRIGGERS listed below. Maybe I am confused by the text of the
> message. There is a CLOB in the table, not a long. Note that there is
> a to_lob to convert the long to clob from user_triggers.
You hint at what's doing the INSERT, but don't say explicitly. Is it a DDL trigger? Have you tried tracing the INSERT to see exactly where the problem is?
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 25 2012 - 12:50:48 CDT