This discussion is archived
2 Replies Latest reply: Dec 14, 2012 11:23 AM by 943610 RSS

WITH HOLD problem when  common_parser=yes compiler option used

979552 Newbie
Currently Being Moderated
Hi guys,

we are using Oracle 11g precompiler and we start using "common_parser=yes" option because of JOIN keyword, but now WITH HOLD in DECLARE CURSOR statements is not supported.

So, the statement :
EXEC SQL DECLARE cur_name CURSOR WITH HOLD FOR SELECTc1, c2 FROM t1

gives an error when "common_parser=yes" is present
PCC-S-02201, Fand das Symbol "WITH" als eines der folgenden erwartet wurde:
for,

and when is not, we can compile this statement but we get the same error for JOIN (and we dont wont to rewrite JOIN statemnts to old syntax with +).

Is this a bug and is there a workaround or solution for this problem?

Thanks in advance,
DO


PS

We also noticed the same problem for LOB statements:
EXEC SQL LOB WRITE ONE :lob FROM :buffer WITH LENGTH :bufferlen ...
Again, WITH is not recognised

Edited by: 976549 on 13.12.2012 02:20

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points