Workaround to ORA-25003 on Oracle 8i

From: Isaac Chocron <itshak_at_hadassah.org.il>
Date: Sun, 09 May 1999 10:07:45 +0300
Message-ID: <37353441.369638FE@hadassah.org.il>

I'm searching a work around for the next problem:

1. I created a type like

CREATE OR REPLACE
Type OT1
AS OBJECT
(

    a     varchar2(10),
    b     integer,

    MEMBER PROCEDURE Fill_instance
);
/

CREATE OR REPLACE
Type Body OT1
IS
member PROCEDURE Fill_instance
IS
begin

    a := 'ok';
    b := 10;
END fill_instance;
END;
/

2) I created a table like

CREATE TABLE t
(

    t1     VARCHAR2(10) NOT NULL,
    t2     OT1

)
/

3) I tried to create a trigger like

CREATE OR REPLACE TRIGGER tr_t_bef_ins
BEFORE INSERT
ON t
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Begin

    :new.t2.fill_instance;
End;
/

... and I received the error:

ORA-25003: cannot change NEW values for this column type in trigger

My Server is an ORACLE 8i on NT (4.0)

Received on Sun May 09 1999 - 02:07:45 CDT