PLSQL Unit Can Fail In 12.2 Database During Compilation/Runtime When Using JSON_* In The Code (Doc ID 2259772.1)

Last updated on MAY 02, 2017

Applies to:

PL/SQL - Version 12.2 BETA1 and later
Information in this document applies to any platform.
*** Checked for relevance on 2nd May 2017 ***

Symptoms

1) PL/SQL unit using custom version of JSON_* function/procedure/type/type body fails to compile/run from 12.2.0.1.0 version.

2) Same code would compile/run fine till 12.1.0.2.0 version of database.

Some sample code(s): 

Both the code fails with "PLS-00103 Encountered the symbol when expecting one of the following"

Changes

Upgraded oracle database from lower version to 12.2.0.1.0

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