Hi,
ECPG don’t support the following scenario:
char cur_name = “cur1”;
EXEC SQL DECLARE :cur_name CURSOR FOR …
EXEC SQL OPEN :cur_name;
EXEC SQL FETCH cur1 INTO…
…
EXEC SQL CLOSE :cur_name;
An compile error will occur for above codes because ECPG can’t find the “cur1”.
But it does support the following scenario:
char cur_name = “cur1”;
EXEC SQL DECLARE :cur_name CURSOR FOR …
EXEC SQL OPEN :cur_name;
EXEC SQL FETCH :cur_name INTO…
…
EXEC SQL CLOSE cur1;
Does the second scenario is a bug for ECPG? Will anyone use the second scenario to close an CURSOR that is named by a variable?
Kind regards,
Jing