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.
Oracle 26ai
ORA-04046
Error Message
results of compilation are too large to support