ORA-00600: internal error code, arguments: [12840] while compiling a package
Posted by Kamran Agayev A. on 18th March 2011
While compiling a pacakge on 9i db , I’ve encountered the following error:
[code]
ORA-00600: internal error code, arguments: [12840], [], [], [], [], [], [], []
[/code]
There’s was a public synonym on 9i side which was referred to the table on the remote database that is running on 10gR2
After a little research I’ve found out that it’s a bug and I need to create a view and call that public synonym from that view. Fortunately, by creating a view, I was able compile a package successfully 
For more information, check the following metalink note:
Bug 4116405: ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [12840] ON COMPILING AN PROCEDURE
Posted in Administration | No Comments »