ORA-04046: results of compilation are too large to support
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.
Action:
Reduce the size of the store procedure by splitting it into smaller stored procedures.