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

Home -> Community -> Usenet -> c.d.o.server -> stuff CLOB in trigger

stuff CLOB in trigger

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 17 Oct 2001 23:05:58 GMT
Message-ID: <9ql2sm$8c4@dispatch.concentric.net>


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

Original text of this message

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