Problem inserting firebird data into ubuntu

0

I am using firebird in Ubuntu and when performing an insert the following error appears:

  

invalid request BLR at offset 230; function STRLEN is not defined; module name or entrypoint could not be found [SQLState: HY000, ISC error code: 335544343]

Looking at the file ib_udf.sql the strlen function is already there. What can I be missing out on?

DECLARE EXTERNAL FUNCTION strlen
    CSTRING(32767) CHARACTER SET NONE
    RETURNS INTEGER BY VALUE
    ENTRY_POINT ''IB_UDF_strlen'' MODULE_NAME ''ib_udf'';

The query I'm using does not even use strlen:

  

INSERT INTO CRACHES (CODPERFIL, STATUS, QUEM_DESABILITOU, VALID, CRACHA, ULT_HABILITACAO, RETEM, QUEM_HABILITOU, ULT_DESABILITACAO, VALIDADE_INDETERMINADA)   VALUES ('1', 'D', NULL, NULL, IIF ('20101449' = '', LPAD ('2' || LPAD (1449, 7, '0')) LPD ('20101449', 16, '0')), NULL, 'N', 'CATRACA', NULL, 'S')

    
asked by anonymous 23.11.2018 / 14:49

0 answers