Compile Oracle Package Error

Sometimes you didn’t receive informative error when compiling the Oracle Package using TOAD. The error message shown in TOAD doesn’t help much in troubleshooting. So usually I advise you to compile the Oracle Package using the SQL Plus in your local or server side.

Follow the sequence of command as below and you will got the details why the compilation of a package fails.

Compile Oracle Package In SQL Plus

SQL*Plus: Release 10.2.0.1.0 - Production
 
SQL> SET serveroutput ON;
SQL> ALTER package APPS.CSF_DEBRIEF_UPDATE_PKG compile body;
 
Warning: Package Body altered WITH compilation errors.
 
SQL> SHOW err
Errors FOR PACKAGE BODY APPS.CSF_DEBRIEF_UPDATE_PKG:
 
LINE/COL ERROR
-------- -----------------------------------------------------------------
1030/7   PL/SQL: Statement ignored
1030/7   PLS-00306: wrong NUMBER OR types OF arguments IN CALL TO
         'UPDATE_ROW'