Oracle Solution for Error ora-04046

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

What triggered 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.

What should we do to fix it:

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