Re: Error with Clob

Tmo_hsqldb_q <[email protected]> Fri, 22 Mar 2013 10:37:47 -0700 (PDT)

Newsgroups	gmane.comp.java.hsqldb.user
Message-ID	<[email protected]>

Hi Fred

I might have misunderstood the point you made: "LONGVARCHAR is simply an
alias for VARCHAR(16M)"
I tried the following but get an error when creating the Trigger: 
"unexpected token: 20M : line: 4 / Error Code: -5581 / State: 42581"


CREATE TABLE testtable3 
( 
   clobcolumn CLOB(20M)     NOT NULL 
); 


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(20M))); 




--
View this message in context: http://hsqldb.10974.n7.nabble.com/Error-with-Clob-tp151p3863.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