|Subject||Upgrade Firebird 1.5.3 to 2.5.4 - function F_STRINGLENGTH is not defined|
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$QUERY_NAME: <Empty String>
What could the issue be?