Gen Inline Code precompile error PCC-S-02201 'Encountered the symbol "over" ...'

Products

• Gen
• Gen - Workstation Toolset

Issue/Introduction

Using Gen 8.6 Inline Code code feature to create embedded SQL targeting Oracle and receive precompile error:
PCC-S-02201, Encountered the symbol "over" when expecting one of the following:
   ) * + - / | at, day, hour, minute, month, second, year,

The coded statements run without error outside of Gen compiled code as standalone SQL.

Environment

Gen 8.6 Inline Code for Oracle SQL

Resolution

In '$ORACLE_HOME/precomp/admin/' directory, change the file pcscfg.cfg by adding: 'common_parser=yes' at the end of the configuration.
After making that change, the program compiles successfully.

NOTE:
This problem is not specific to Gen and for these type of errors, the recommendation is to:

1. Copy and paste the Inline Code source code into a source module (.sqc) and then invoke the Oracle precompiler (proc) with the same parameters that are used within Gen (can look in a .out file for a compiled Gen module for these parameters).
   
   
2. If the same errors are received when doing that, then use that source module as a mechanism for cleaning/fixing the syntax until it can precompile without errors.
   
   
3. Place the final code which precompiles successfully in the Inline Code area and it should precompile there as well.