My Oracle Support Banner

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

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