db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Narayanan <V.Naraya...@Sun.COM>
Subject Re: jdbc:default:connection fails
Date Sun, 23 Mar 2008 16:30:32 GMT

> /*
> Declared as follows:
> CREATE FUNCTION GetActiveOrg (status STRING)
> RETURNS VARCHAR(255)
> LANGUAGE JAVA
> PARAMETER STYLE JAVA
> READS SQL DATA
> EXTERNAL NAME 'com.mymunshi.derbyfunctions.ActiveOrg.GetActiveOrg'
>
>
You have used the STRING datatype here, running the same command in gives me

ERROR 42X01: Syntax error: Encountered "status" at line 1, column 31.

changing String to VARCHAR(20) makes this definition work.

Narayanan

Mime
View raw message