ORA-600 [15419] Error When Running PL/SQL Procedure with User-Defined Exception
Last updated on MARCH 07, 2016
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]Information in this document applies to any platform.
Symptoms
When running a specific procedure, an ORA-600 [15419] error is reported in the alert log like:
ORA-06544: PL/SQL: internal error, arguments: [77410], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [77410]
ORA-04061: existing state of package body "TMS.IF_RFID" has been invalidated
ORA-04065: not executed, altered or dropped package body "TMS.IF_RFID".
ORA-06508: PL/SQL: could not find program unit being called(: "TMS.IF_RFID").
The trace file shows following characteristics:
Current SQL statement for this session:
DECLARE myexc EXCEPTION; PRAGMA EXCEPTION_INIT (myexc, -6508);BEGIN RAISE myexc; END;
----- PL/SQL Call Stack -----
object line object
handle number name
3cb3d5458 469 package body TMS.COM_ERRPKG
3cb3d5458 284 package body TMS.COM_ERRPKG
3cb3d5458 579 package body TMS.COM_ERRPKG
3d3bfbd00 3806 package body TMS.PDA_IMP_OUT2
3d9904630 1 anonymous block
----- Call Stack Trace -----
... kkxexe opiexe opipls opiodr rpidrus skgmstack rpidru rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr ...
Manually running the exception code also throws an error PLS-801: "internal error [77410]":
NOTE: No invalid objects were found in the dba_objects view.
Changes
Newly created package.
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms