db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wil Hunt <w...@lunarlogic.com>
Subject Re: Regular Expression Searching with Clob Data
Date Fri, 14 Jan 2005 20:47:27 GMT
Yes I noticed this when I tried to install the function.  What I was 
hoping for was a way "around" this limitation.  So I presume that there 
is not, and I'll have to just not search that field.

Thanks,

Wil

Satheesh Bandaram wrote:

>Derby currently doesn't support Long Varchar/CLOB/BLOB datatypes as
>function/procedure parameters. It is documented in the reference manual:
>http://incubator.apache.org/derby/manuals/reference/sqlj27.html#CREATE+FUNCTION+Statement
>
>Satheesh
>
>Wil Hunt wrote:
>
>  
>
>>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