1 Reply Latest reply: Dec 12, 2012 2:10 PM by orafad RSS

    WITH HOLD in declare cursor statement and common_parser=yes compiler option

    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 +).

      Can somebody help us?

      Thanks in advance,
      DO