In this post, you’ll learn more about the Oracle ErrorPLS-00996: out of memory with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLS-00996: out of memory
Reason for the Error PLS-00996: out of memory
A request from PL/SQL for more memory failed.
How to fix the Error PLS-00996: out of memory ?
You can fix this error in Oracle by following the below steps
Make sure that you are not referencing the wrong row in a PL/SQL table and that the program is not recursing too deeply.