Re: ORA-04093

From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 25 Jun 2012 12:50:48 -0500 (CDT)

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-l

References:

ORA-04093
From: Causey, Bob

Re: ORA-04093

Other related posts: