PL/SQL Unit Fails to Compile With PLS-00801 When Using REVERSE Keyword With Cursor Loop.
Last updated on OCTOBER 05, 2017
Applies to:PL/SQL - Version 18.104.22.168 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms