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:PL/SQL - Version 126.96.36.199 and later
Information in this document applies to any platform.
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.
Upgraded the database to 12c or it is a new implementation in 12c database.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document