Subject How to: Stored procedure returns blob field like text
Author Roland Turcan
Hello IB-Support!

I have this SP:

CREATE PROCEDURE VRAT_UROKY (
SPIS INTEGER)
RETURNS (
OUTPUT_TEXT BLOB sub_type 0 segment size 80)
AS
BEGIN
SELECT 'AJSDKLAJDADAD' FROM RDB$DATABASE INTO :OUTPUT_TEXT;

SUSPEND;
END

but if I tried this statement:

select * from vrat_uroky(1121);

I get this error messsage:
internal error
select * from vrat_uroky(1121)

But I need get long string, but I don't know how length will be.
May be longer like max varchar variable.

Thank for all solutions.

--
Best regards, TRoland
http://www.rotursoft.sk