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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22990: LOB locators cannot span transactions

1 Answers  


PCC-00016: Unable to open a cursor at line number in file string

1 Answers  


ORA-12984: cannot drop partitioning column

1 Answers  


LSX-00281: referenced ID "~S" is not defined

1 Answers  


PLS-00393: wrong number of columns in SELECT...INTO statement

1 Answers  






ORA-39145: directory object parameter must be specified and non-null

1 Answers  


ORA-12219: TNS:missing community name from address in ADDRESS_LIST

1 Answers  


ORA-22819: scope of input value does not correspond to the scope of the target

1 Answers  


SQL*Loader-00268: UNRECOVERABLE keyword may be used only in direct path.

1 Answers  


ORA-10581: Can not modify redo log header during test recovery

1 Answers  


QSM-01090: no query rewrite after view merging

1 Answers  


RMAN-06012: channel: string not allocated

1 Answers  


Categories