description: When
create procedure copy_companyinfo()
as
declare variable item1 varchar(20);
declare variable item2 varchar(20);
declare variable item3 varchar(20);
.....
declare variable item257 varchar(20);

begin

for execute statement ' select item1,item2 ......item257 from atable ' into :item1 , :item2 ....... ,item257
do
begin
end
---------------------------

Cannot commit transaction:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error while parsing procedure COPY_COMPANYINFO's BLR.
invalid request BLR at offset 9054.
BLR syntax error: expected statement at offset 9055, encountered 0.

firebird 2.5 is fine.

=>

When
create procedure copy_companyinfo()
as
declare variable item1 varchar(20);
declare variable item2 varchar(20);
declare variable item3 varchar(20);
.....
declare variable item257 varchar(20);

begin

for execute statement ' select item1,item2 ......item257 from atable ' into :item1 , :item2 ....... ,item257
do
begin
end
---------------------------

Cannot commit transaction:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error while parsing procedure COPY_COMPANYINFO's BLR.
invalid request BLR at offset 9054.
BLR syntax error: expected statement at offset 9055, encountered 0.

firebird 2.5 is fine.
restore db.gbk from 2.5 to 3.0 this procedure issue error:
gbak: ERROR:invalid request BLR at offset 15362
gbak: ERROR: BLR syntax error: expected unknown EXECUTE STATEMENT option at offset 15363, encountered 26
gbak:Exiting before completion due to errors

security: Developers [ 10012 ] =>

Attachment: test25.gbk [ 12961 ]

Attachment: TEST25.FDB [ 12962 ]

assignee: Dmitry Yemanov [ dimitr ]

Version: 4.0 Initial [ 10621 ]

Fix Version: 3.0.1 [ 10730 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

summary: execute statement More than 256 return value error => EXECUTE STATEMENT: BLR error if more than 256 output parameters exist

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]