db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik.Bengt...@intl.westernunion.com
Subject RE: cant' get user defined function to work
Date Mon, 26 Sep 2005 15:54:14 GMT
Deepa,

>If you define a function using 'CREATE FUNCTION ...' and call it using
>CALL {function} statement, you get the same error as above. To call a
>function in Derby, either VALUES or SELECT has to be used.
>e.g: VALUES JPOX_ASCII('a');


I use 
SELECT 1 FROM TABLE WHERE JPOX_ASCII('a') = 55


Regards,

Erik Bengtson
RE

Mime
View raw message