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
begin:vcard
fn:Wil Hunt
n:Hunt;William
org:Lunar Logic, Inc.
adr:;;488 E. 11th;Eugene;OR;97403;USA
email;internet:[EMAIL PROTECTED]
title:Developer
tel;work:541.684.9500 x1182
tel;cell:541.912.6987
x-mozilla-html:FALSE
url:http://www.lunarlogic.com
version:2.1
end:vcard
