PL/SQL Unit Fails to Compile With PLS-00801 When Using REVERSE Keyword With Cursor Loop. (Doc ID 2314440.1)

Last updated on JULY 02, 2023

Applies to:

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

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