PL/SQL Unit Fails to Compile With PLS-00801 When Using REVERSE Keyword With Cursor Loop.

(Doc ID 2314440.1)

Last updated on OCTOBER 05, 2017

Applies to:

PL/SQL - Version 12.1.0.1 and later
Information in this document applies to any platform.

Symptoms

In 12c, PL/SQL compilation is failing with "PLS-00801: internal error" when using the REVERSE keyword in cursor for loop. Same code was getting compiled file in 11g and lower versions.

For example, the below PL/SQL code when compiled with fail with internal error from 12c onwards.

 

Changes

Upgraded the database to 12c or it is a new implementation in 12c database. 

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