[EMAIL PROTECTED] wrote:
Hi,
I’ve created the following function:
DROP FUNCTION JPOX_ASCII;
CREATE FUNCTION JPOX_ASCII(C CHAR(1)) RETURNS INTEGER
EXTERNAL NAME 'org.jpox.store.rdbms.adapter.Function.ascii'
CALLED ON NULL INPUT
LANGUAGE JAVA PARAMETER STYLE JAVA;
package org.jpox.store.rdbms.adapter;
public final class Function
{
/**
* ASCII conversion code
* @param code
* @return
*/
public static int ascii(String code)
{
return (int)code.charAt(0);
}
}
Erik's function worked for me when I changed this:
public final class Function
to this:
public class Function
ij> values jpox_ascii('c');
1
-----------
99
1 row selected
-jean
