Czech Localization : CLE_F078_FA_CHMATE_PKG compilation error wrong number of values in the INTO list of a FETCH statement
(Doc ID 2513973.1)
Last updated on SEPTEMBER 19, 2024
Applies to:
EMEA Add-on Localizations - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2 version, General
Find that package body 'CLE_F078_FA_CHMATE_PKG' is in 'INVALID' state.
When attempting to manaully compile invalid object 'CLE_F078_FA_CHMATE_PKG',the following error occurs.
ERROR
-----------------------
SQL> alter package APPS.CLE_F078_FA_CHMATE_PKG compile body;
Warning: Package Body altered with compilation errors.
SQL> show err
Errors for PACKAGE BODY APPS.CLE_F078_FA_CHMATE_PKG:
LINE/COL ERROR
-------- -----------------------------------------------------------------
155/6 PL/SQL: SQL Statement ignored
155/6 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
395/5 PL/SQL: SQL Statement ignored
395/5 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
412/8 PL/SQL: SQL Statement ignored
412/8 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
419/10 PL/SQL: SQL Statement ignored
419/10 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
445/7 PL/SQL: SQL Statement ignored
445/7 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
452/7 PL/SQL: SQL Statement ignored
452/7 PLS-00394: wrong number of values in the INTO list of a FETCH
statement
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the noted object cannot be successfully compiled.
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 |