Re: How to escape hints in PL/SQL

From: sidey <sideyt_at_hotmail.com>
Date: 29 Aug 2006 15:41:50 -0700
Message-ID: <1156891310.909014.148530@e3g2000cwe.googlegroups.com>

Oracle SQL Developer puts a little red underscore right after ujvc

ujvc := '/' || CHR(42) || '+bypass_ujvc */';

  sql_stmt := 'UPDATE ('
|| 'SELECT' || ujvc || ' t1.' || c1 || ' c1 '

                        ^ _____________________little red thing

|| 'from ' || mytab ' t1, ' || mytab ' t2 '
|| 'where t1.rowid > t2.rowid '
|| 'and t1.qsn = t2.qsn '
|| 'and t1.qsn2 = t2.qsn2 '
|| ') ' ||

    'set c1 = -1';

  and won't compile the procedure:

Error(135,26): PLS-00103: Encountered the symbol " t1, " when expecting one of the following: . ( * @ % & = - + ; < / > at in is mod remainder not rem <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || member SUBMULTISET_ Received on Tue Aug 29 2006 - 17:41:50 CDT