Subject | How to: Stored procedure returns blob field like text |
---|---|
Author | Roland Turcan |
Post date | 2003-01-31T12:30:42Z |
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
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