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 |
