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


Other related posts:

  • » ORA-04093 - Causey, Bob
  • » Re: ORA-04093 - Rich Jesse