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
