db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Regular Expression Searching with Clob Data
Date Fri, 14 Jan 2005 01:40:41 GMT
Derby currently doesn't support Long Varchar/CLOB/BLOB datatypes as
function/procedure parameters. It is documented in the reference manual:


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

View raw message