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

ERRORresults of compilation are too large to support
CAUSEAttempt to compile and store a large stored procedure that results in compilation data that is too large for the system to support or store.
ACTIONReduce the size of the store procedure by splitting it into smaller stored procedures.