I get an "internal error" with my procedure that has a BLOB parameter:
Calling P_TRANS_TEST in the following code shows the result.

Can anybody explain or even better give me a hint/solution besides changing
type of PAR to varchar(..)?

SET TERM ^ ;

CREATE PROCEDURE P_TRANS_TEST_MEMO (PAR BLOB SUB_TYPE 0 SEGMENT SIZE 80)
AS BEGIN EXIT; END^

CREATE PROCEDURE P_TRANS_TEST
AS
BEGIN
execute procedure P_TRANS_TEST_MEMO(null); -- works
execute procedure P_TRANS_TEST_MEMO(''); -- dies with internal error
execute procedure P_TRANS_TEST_MEMO(ltrim('')); -- dies too
END^

SET TERM ; ^

BTW.: I tried this on Firebird 1.5 WI-V1.5.1.4481 on Win XP (but assume,
the problem will be present somewhere else too).

Thank you for help, Thomas



--
Thomas.Beckmann@...
Martens & Prahl EDV, Wielandstr. 14c, 23558 Lübeck
Telefon 0451-39904-525 • Telefax -559