db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wil Hunt <w...@lunarlogic.com>
Subject Regular Expression Searching with Clob Data
Date Thu, 13 Jan 2005 00:33:47 GMT
Hey all,

    I'm looking for a mechanism that will allow regular expression 
searching for CLOB data.  I can setup a function to do it for 
VARCHAR(x), but Derby complains when I try to do it with a CLOB.

ERROR 42962: Long column type or paramter 'SOURCE' not permitted in 
declared global temporary tables or procedure definitions.

    Is there a way around this?

Thanks,

Wil

Mime
View raw message