CREATE PROCEDURE answers_select_id (IN question_id bigint ) P1:BEGIN DECLARE cursor1 CURSOR WITH RETURN TO CLIENT FOR SELECT a.answer_id from answers as a where a.question_id = question_id; open cursor1; END P1;
I am using the same java code with mysql stored procs . It works fine there but I assume open cursors in db2 stored proc is causing the problem . If I can help it , I need to maintain the same java code for mysql ad db2 . Please help me ...
subject: Resultset returns null from a srored procedure in db2