Subject | [ib-support] How to: Stored procedure returns blob field like text |
---|---|
Author | Roland Turcan |
Post date | 2003-01-31T14:23:39Z |
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
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
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
To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/