| 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
![]()  | 
![]()  |