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

 

Reply via email to