Cause: Attempt to compile and store a large stored procedure that results in compilation data that is too large for the system to support or store. See the solution below.
Error solution: Reduce the size of the store procedure by splitting it into smaller stored procedures.
Database version: Oracle 11g Release 2 (11.2)