Logo Background

Compile Oracle Package Error

  • By on November 1, 2009 | 1 Comment

    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'
    Previous
    Next
    » Solve Oracle Enterprise Manager Error
Leave a Comment