Dear Oracle experts,
I need help. I installed toad and somehow, i compiled my plsql procedure with debug mode option through TOAD. compilation failed due to too may values error. After that, dropped the plsql package and creating the package from sql prompt. still during the package creation, it is giving the below erorr. It should give only on run time. But it is giving the below error on procedure creation time. I would appreciate if any one can hlep me on this.
SQL> start c:/checkin/INVENTORY.SQL
Warning: Package Body created with compilation errors.
SQL> show err
Errors for PACKAGE BODY INVENTORY:
LINE/COL ERROR
-------- -----------------------------------------------------------------
365/4 PL/SQL: SQL Statement ignored
365/21 PL/SQL: ORA-00913: too many values
SQL>