Precompilation of OUTER JOIN Statements Fails With PCC-02201 or PCB-00400 (Doc ID 253664.1)

Last updated on JULY 05, 2017

Applies to:

Precompilers - Version 9.0.1 to 10.2.0.4 [Release 9.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 25-Nov-2013***

Symptoms

How to Reproduce:
 

  EXEC SQL DECLARE c1 CURSOR  FOR select empno, ename , dname from emp_new e  LEFT OUTER JOIN  dept_new d on (e.deptno = d.deptno); /* or other forms of Join (RIGHT, FULL OUTER)*/

 

$ proc iname=programname.pc

  PCC-S-02201, Encountered the symbol "LEFT" when expecting one of the
  following:
   ; , for, union, connect, group, having, intersect, minus,
   order, start, where, with,      


Symptoms:

PCC-S-02201, Encountered the symbol %s when expecting one of the following: %s
PCB-S-00400, Encountered the symbol "%s when expecting one of the following: %s
PCC-S-0061:  Error at line %s, column %s. PLS-00103: Encountered the symbol "OUTER" when expecting one of the following: %s

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms