Oracle DBA, How To, Error, Cause and Action

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

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.