My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2024

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.

Symptoms

How to Reproduce:
 

 

$ 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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.