Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> stuff CLOB in trigger
How can I get around this? I want to update :new.myclob in trigger. Oracle
says no can do on this type.
select cust.myotherclob
into :new.myclob
from cust
where cust.cust_id = ( select cust_id
from order where order.cust_id = :new.cust_id );
Thanks
-- Jim Poe (jpoe_at_fulcrumit.com)Received on Wed Oct 17 2001 - 18:05:58 CDT
![]() |
![]() |