2 Replies Latest reply: Dec 14, 2012 1:23 PM by 943610 RSS

    WITH HOLD problem when  common_parser=yes compiler option used

    979552
      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