A stored procedure, debugging is not a problem, but in C # run Error:
ora-01036: Illegal variable name/number
Baidu, it is said that because a lot of errors will be reported this mistake, did not find the right me (parameter order matching, size matching, etc.), have to try again:
The method I called:
oracleparameter[] Parameters ={
new OracleParameter ("Vipno", Orac letype.varchar,50),
/ nbsp New OracleParameter ("point", oracletype.varchar,30),
nbsp new OracleParameter ("Str_reason", oracletype.varchar,20), / /str_reason I have a space here,
New OracleParameter ("Myresult", Oracletype.int32)
&NBSP ; };
Finally have to keep only one parameter, to debug, that is, the stored procedure only the first parameter, I call only with one parameter, the other parameters commented out, after testing no problem.
About the third parameter when the problem is found, my "" Inside and the third parameter of the stored procedure than a space, because of this space, resulting in this bad lookup error.
The problem is solved by this.
In fact, we have to have a way to try more.
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
ora-01036: Illegal variable name/number