Greetings All,

On a new Windows 7 64 bit computer I installed Firebird v2.5.4 64 bit

I then installed the FreeUDFLib 64bit functions

I then did a firebird v1.5.3 backup of the metadata only and then restored this on firebird v2.5.4. 

I made sure to use the following switches during the restore

-FIX_FSS_D(ATA) <charset> -- fix malformed UNICODE_FSS data

-FIX_FSS_M(ETADATA) <charset> -- fix malformed UNICODE_FSS metadata

Everything appears to be fine as the restore was successful.

I decide to try to compile a stored procedure that used F_STRINGLENGTH and got the following error:

 invalid request BLR at offset 130

function F_STRINGLENGTH is not defined

module name or entrypoint could not be found

Error while parsing procedure DATETIME_TO_STR's BLR

I verified that the function is defined with the following:

select * from rdb$functions where upper(rdb$function_name) = 'F_STRINGLENGTH'

It return one record with the following values:

RDB$FUNCTION_NAME: F_STRINGLENGTH

RDB$FUNCTION_TYPE: 0

RDB$QUERY_NAME: <Empty String>

RDB$DESCRIPTION: <null>

RDB$MODULE_NAME: FreeUDFLib

RDB$ENTRYPOINT: StringLength

RDB$RETURN_ARGUMENT: 0

RDB$SYSTEM_FLAG: 0

What could the issue be?

Thanks,

Mike