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:
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