Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't compile package body

908197Jun 9 2012 — edited Jun 9 2012
hello. i ran in to little issue today. After patch 13839550 was applied to one of our test enviroments, we get one invalid package body. but when i try to compile it shows warrning!


SQL> alter package APPS.AP_ACCTG_DATA_FIX_PKG compile body;

Warning: Package Body altered with compilation errors.

SQL>
SQL> show err
Errors for PACKAGE BODY APPS.AP_ACCTG_DATA_FIX_PKG:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3899/3 PL/SQL: SQL Statement ignored
3899/3 PLS-00394: wrong number of values in the INTO list of a FETCH
statement


Could you please explain what should i do?

Database - 11.2.0
eBS - 12.1
Linux x86

Thx
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2012
Added on Jun 9 2012
4 comments
314 views