ORA-04093

Content-Type: text/plain;
        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@xxxxxxxxxxxx

=20

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

=20




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

Other related posts: