re: need help with ORA-00947
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: re: need help with ORA-00947

  1. #1
    Join Date
    Jan 2004
    Posts
    58

    Unhappy re: need help with ORA-00947

    hi! ,

    I am using sqlplus ...

    I have a procedure x in user abc.
    I am trying to create the same procedure x in user jkl.
    I selected the text from user_source into notepad and saved it
    as a sql file.

    The formatting got all screwed up so I tried my best to format it
    and run the sql file from the sqlplus prompt of user jkl.

    I am geting the following errors ..

    SQL> @c:\tsrtrafficdtalinking.sql

    Warning: Procedure created with compilation errors.

    SQL> show errors
    Errors for PROCEDURE TSRTRAFFICDATALINKING:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    133/20 PL/SQL: SQL Statement ignored
    133/36 PL/SQL: ORA-00947: not enough values
    167/23 PL/SQL: SQL Statement ignored
    167/39 PL/SQL: ORA-00947: not enough values
    211/23 PL/SQL: SQL Statement ignored
    211/39 PL/SQL: ORA-00947: not enough values
    223/23 PL/SQL: SQL Statement ignored
    223/39 PL/SQL: ORA-00947: not enough values
    262/26 PL/SQL: SQL Statement ignored
    262/42 PL/SQL: ORA-00947: not enough values
    275/26 PL/SQL: SQL Statement ignored
    275/42 PL/SQL: ORA-00947: not enough values

    How do I rectify this ???

    Is there any where of directly creating the procedure in user jkl
    without having to create a sql file and then running the sqlfile ..??

    thanks,
    harish
    thanks,
    harish

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Can you post some of the statements creating the errors (as shown by the error line code), It sounds like some typos have been made during the reformatting.

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jan 2004
    Posts
    58

    Unhappy PROBLEM WAS ....

    FYI,

    the problem was an insert statement in the code that was inserting four values into five columns ....

    i thought it was a formatting error
    thanks,
    harish

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