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 -- //www.freelists.org/webpage/oracle-l