Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> problem using long raw in trigger

problem using long raw in trigger

From: Minicooper News <Minicooper_at_quadrat.be>
Date: 2000/05/12
Message-ID: <Q3TS4.88$Qt4.2294@nreader2.kpnqwest.net>#1/1

I need to write a trigger that copies a value out of one table into another and i'm experiencing great troubles in copying the LONG RAW field.

for example:

table: Y ( Y1 integer, Y2 varchar2(20), Y3 long raw) table: X ( X1 integer, X2 varchar2(20), X3 long raw)

trigger: Y to X before insert or update on Y referencing new as new and old as old for each row

           begin
                insert into X (X1,X2,X3) values (:new.Y1, :new.Y2, 
:new.Y3);
           end;


now i only get the first 2 values in the table without the long raw !!

Can any1 help me here !!!!!??????

mailto:jurgen_at_quadrat.be

--
Received on Fri May 12 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US