PLSQL package failing while creating the package
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: PLSQL package failing while creating the package

  1. #1
    Join Date
    Dec 2005
    Posts
    195

    PLSQL package failing while creating the package

    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>

  2. #2
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    is it a forward "/" or a backward "\"
    you have to show the package dear for us to debug
    Behind The Success And Failure Of A Man Is A Woman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width