-
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
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|