| From: | "Wang, Jing" <jingw(at)fast(dot)au(dot)fujitsu(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Cc: | "Arulappan, Arul Shaji" <arul(at)fast(dot)au(dot)fujitsu(dot)com>, "Boguk, Maksym" <maksymb(at)fast(dot)au(dot)fujitsu(dot)com> |
| Subject: | Is this a bug in ECPG? |
| Date: | 2013-09-06 00:57:38 |
| Message-ID: | F9AB2AFB133B614987F30E6015FCBFC1ED6737@ack0102.au.fjanz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Suzuki Hironobu | 2013-09-06 02:17:16 | Re: Question About WAL filename and its time stamp |
| Previous Message | Janek Sendrowski | 2013-09-05 23:00:10 | Levenshtein Distance with more than 255 characters |