Oracle Error ORA-04046: results of compilation are too large to support

Oracle Error Message

ORA-04046: results of compilation are too large to support

Reason for the Error

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.

Solution

Reduce the size of the store procedure by splitting it into smaller stored procedures.