GrassField

Again an update caused this this issue. I had dropped a few columns from a table here and there. I have updated the necessary procedure populates that table. Beautifully, I executed the java code, loading that table with out changing that. varchar is assigned to date and viceversa. I hit with this issue. PLS-00306 Error: Wrong number of types of arguments in call to procedure So, no way, I corrected them all. and it is working fine

This is a silly mistake. Let me tell you what. I am inserting some values to a table. see the following query.

insert into mytable (col1, col2) values ('tanya', 'mega', 'harish')
ORA-00913: too many values

so you got it we can identify this easily when updating less number of variables, I was updating 90+ columns, and I have given some extra values. what to do.. remove the extra..!

http://www.techonthenet.com/oracle/errors/ora00913.php

Hi,I had created some procedure and I tried to execute it with sqlplus. That time I hit with this error.

SQL>@ c:\temp\uploaddata.sql
SP2-0734: unknown command beginning "upload [..." - rest of line ignored.

actually upload is a local variable I am trying to declare and assign some value. but I found later there are some unwanted characters being entered in the sql file. On removing it, it is running like a tiger! Sometimes, there may be some formatting characters inserted by editors also cause this error, somebody told in some website!

I had successfully compiled a procedure. Later, I did some changes to the table, which is being populated by that table. I dropped a few columns and added a few columns. To prove I am a human, I dint update that procedure. End, I hit with this error.

PLS-00905: Object UPDATE_TABLE is invalid.

So I had made the necessary changes to the procedure also and recompiled it. Now, it is working fine.

Here is another problem. A community problem between oracle and perl . I have installed Active Perl in my machine. It was working fine. Later I installed an oracle instance. Thats all. Now Oracle is working fine, but not Perl. Whenever I execute a Perl module, I will be getting a dialog box saying,

Perl : Unable to Locate Component. perl58.dll was not found

Later I found that the perl module used by Oracle internally overrides the default settings. One of the posts in ActiveState.com forum helped me to identify this. When I unset PERL5LIB environmental variable, It started working fine