Long datatypes and Trigger

I have a column with LONG datatype. I need to insert this column in a audit table via trigger whenever a new row is inserted. The corresponding column in the audit table is also LONG. Here are the details.

SQL> desc t1;

 Name                            Null?    Type


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

 P                                        LONG

SQL> desc t2;
 Name                            Null?    Type


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

 P                                        LONG

create trigger T1_T1
BEFORE INSERT ON T1
FOR EACH ROW
  DECLARE
BEGIN
 INSERT INTO T2 values (:new.p);
END; When I insert a row in t1, the trigger inserts a row in t2 but it is NULL. I understand the current restriction on LONG datatype. Is there any way to correct value into t2 ?

thanks,

venkata kowluri Received on Wed Sep 10 1997 - 00:00:00 CDT