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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.