/* 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
