Logo Background
Home
Database
Compile Oracle Package Error

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'
Leave a Comment Leave a Comment
1 Comment
Leave a Comment

Recent Comments

  • oracle: How about using DBMS_REDEFINITION? It might produce the same result like alter table shrink space command but...
  • ashok: If you are going to reuse back the space then there’s no need to re-org. However, check this out. APPEND...
  • andy: Yes, the shrink command will shrink the size of the table and reduce the high water mark (HWM) of the table. If...
  • shubhod salian: Hi Indu, You need to execute adadmin on node B , simply because your forms server resides on this...
  • hari: May I know what is the referred meta link for the permanent solution.

RSS

Copyright © 2010 The Guru Network