Posted on 2005-05-13
I am trying to declare some of the UDF's from the IB library here is the SQL I am using.
DECLARE EXTERNAL FUNCTION div
RETURNS DOUBLE PRECISION BY VALUE
ENTRY_POINT 'IB_UDF_div' MODULE_NAME 'ib_udf';
When I compile a stored procedure trying to use the div function I get an error
"Invalid token.invalid request BLR at offset 284.
function DIV is not defined.
I do run the declare function before trying to compile the stored procedure that uses it.