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 ***


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

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

Some sample code(s): 

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


Upgraded oracle database from lower version to


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