Hello.
v8.2.7, windows xp.
---
create procedure cursor_test()
language sql
dynamic result sets 1
begin
declare c1 cursor
--with hold
with return for
select * from sysibm.sysdummy1;
open c1;
end@
create procedure cursor_test2(out p_out char(1))
language sql
begin
DECLARE loc1 RESULT_SET_LOCATOR VARYING;
call cursor_test();
commit;
ASSOCIATE RESULT SET LOCATOR (loc1)
WITH PROCEDURE cursor_test;
ALLOCATE C1 CURSOR FOR RESULT SET loc1;
OPEN C1;
FETCH C1 INTO p_out;
CLOSE C1;
end@
---
statement
call cursor_test2(?);
leads to instance crash.
All works as expected when I comment "commit" statement in
cursor_test2 procedure or declare c1 cursor as "with hold" in
cursor_test procedure.
Sincerely,
Mark B.