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

Home -> Community -> Usenet -> c.d.o.misc -> CLOBs in Triggers - assigning to :new.XXXX

CLOBs in Triggers - assigning to :new.XXXX

From: <whitegoose_at_inorbit.com>
Date: 18 May 2005 22:24:10 -0700
Message-ID: <1116480250.438804.118760@z14g2000cwz.googlegroups.com> 





I have searched high and low for an answer to this, can anyone help?



I am writing a BEFORE INSERT trigger on a table with a calumn called
COMMENTS which is of type CLOB. I need to assign a value (another CLOB
from a different table) to :new.COMMNETS - but I understand this is a
problem in Oracle 8.



There must be a way to do this. I am aware of DMBS_LOG but I can't
manage to get it working.



Does anyone have a solution?
Received on Thu May 19 2005 - 00:24:10 CDT












Original text of this message













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