ORA-04093

        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable 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.

=20

I know it is the trigger because if I disable it or drop it the function runs fine. Does the ORA_04093 really mean there cannot be a trigger on a table with a CLOB defined even though the trigger does not reference the CLOB? I would really like to know before I start looking for a workaround.=20

=20

Thanks,

Bob

=20

=20

=20

=20

=20

=20

=20

=20

=20

=20

=20

SQL> desc lgty_save_triggers

Name                                      Null?    Type

----------------------------------------- --------
----------------------------

SEQ_NBR                                   NOT NULL NUMBER(9)

TRIGGER_NAME                              NOT NULL VARCHAR2(30)

TABLE_NAME                                NOT NULL VARCHAR2(30)

TRIGGER_DESCRIPTION                       NOT NULL VARCHAR2(4000)

TRIGGER_BODY                              NOT NULL CLOB

=20

SQL>
=20

CREATE OR REPLACE TRIGGER TR_SAVETRG_BI   BEFORE INSERT   on lgty_save_triggers

  for each row

declare

            seqnbr number;

       begin

            IF :new.seq_nbr IS NULL

            OR :new.seq_nbr =3D 0

            THEN             select lgty_save_triggers_seq.nextval into seqnbr from dual;

            :new.seq_nbr :=3D seqnbr;

            end if;

       end;

=20

=20

=20

Bob Causey

Database Administrator

Logility Inc.

phone 404-264-5919

fax 404-364-7617

bcausey_at_logility.com

=20

  <http://logilityconnections.com/>=20

=20

--
http://www.freelists.org/webpage/oracle-l