: "System. Data. OracleClient. OracleException: ORA-06550: 1st rows, 7th columns: \ nPLS-00306: Call 'me

ORACLE prompt: "System. data. oracleClient. oracleException: ORA-06550: 1st rows, 7th columns: \ nPLS-00306: number of parameters or type error when calling 'xxxxxx' \ nORA-06550: 1st rows, 7th columns: \ nPL/SQL: statement ignored \ n \ r \ n Error

Recently, ORACLE databases have been called for plug-ins, and ORACLE has never been used before. However, since it is developed by others, then I can only pull the ORACLE database. During the development process, everything is normal for the program. However, I encountered a problem when calling the stored procedure. I always reported an error in column 7 of the first row. At first, I thought that the parameter was not set correctly, but let's see if all types are the same. It's been bundled for a long time .. Finally, a friend's blog says:

Catch bugs: "System. data. oracleClient. oracleException: ORA-06550: 1st rows, 7th columns: \ nPLS-00306: number of parameters or type error when calling 'Meeting _ NOTICE_CREATE '\ nORA-06550: 1st rows, 7th columns: \ nPL/SQL: statement ignored \ n \ r \ n this error has been tossing me for a long time (several hours), and then throw it to one side. Today, one parameter is excluded and the reason is finally known. T.T

The attribute of the object class does not have an initial value. This error occurs when the null value is inserted. So remember to assign a value. Set string to string. empty.

His URL is: http://www.cnblogs.com/syveen/archive/2007/09/07/885229.html

After reading this, I suddenly looked at it. ORACLE was very strict with data transfer. In the past, when I was doing SQL server, I often wrote NULL for some values, but ORACLE was not good, so I immediately passed the modification test!

The network is really a good resource. If a friend has just encountered such a problem with ORACLE, you may want to check whether it is the problem. This may save you a lot of time.