Error 'PLS-00801: internal error [1401]' received when recompiling packages
(Doc ID 949222.1)
Last updated on JANUARY 16, 2020
Applies to:
Oracle Shipping Execution - Version 11.5.9 to 12.2.2 [Release 11.5 to 12.2]Oracle Order Management - Version 11.5.9 to 12.2.2 [Release 11.5 to 12.2]
Information in this document applies to any platform.
*** Checked for Relevance 27-Apr-2015 ***
Symptoms
-- Problem Statement:
When attempting to recompile OM/WSH database packages after the installation of a new patch the following errors are observed.
SQL> alter package OE_DEFAULT_LINE_PATTR compile body;
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY OE_DEFAULT_LINE_PATTR:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
1604/17 PL/SQL: Statement ignored
Warning: Package Body altered with compilation errors.
SQL> show errors
Errors for PACKAGE BODY OE_DEFAULT_LINE_PATTR:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
0/0 PLS-00801: internal error [1401]
1604/17 PL/SQL: Statement ignored
-- Steps To Reproduce:
1. Open database SQL*Plus session
2. Run the below command to recompile package
alter package OE_DEFAULT_LINE_PATTR compile body;
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |