Re: Error with Clob

Is it possible to dynamically at runtime detect the column size of
newrow.clobcolumn and then use that size and pass it into the
varchar(<size>) in the cast below?


CREATE TRIGGER testtable3_TRIG AFTER INSERT ON testtable3 
referencing NEW ROW AS newrow 
FOR EACH ROW WHEN (newrow.clobcolumn IS NOT NULL) 
CALL testtableupdate3(CAST(newrow.clobcolumn AS VARCHAR(<at runtime enter
size here?>))); 


I know this is not necessary as VARCHAR only allocates the memory that is
required.  But just double checking to see if something like that is
possible.

many thanks,
Tony



--
View this message in context: http://hsqldb.10974.n7.nabble.com/Error-with-Clob-tp151p3866.html
Sent from the HSQLDB - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar