PLS-00306: wrong number or types of arguments in call

  • Thread starter Thread starter Pial
  • Start date Start date
P

Pial

Hi :

I am using Asp.Net, C#, Oracle .

I am trying to execute this Stored Procedure, and it gives me an error
"Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or
types of arguments in call to 'GET_CITY_DATA' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored "

Thanks in Advance
Zahir
 
Pial said:
I am using Asp.Net, C#, Oracle .

I am trying to execute this Stored Procedure, and it gives me an error
"Error Message: ORA-06550: line 1, column 7: PLS-00306: wrong number or
types of arguments in call to 'GET_CITY_DATA' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored "
Click to expand...

Well, the error message seems pretty clear - you're either passing in
the wrong number of arguments, or the types are wrong.

There's nothing more that can really be said without you posting the
code you're using to call it, and the declaration of the stored proc.
 
Are you passing a VARCHAR2 as one of the parameters? When creating the
OracleParameter object, try setting the Size property to 8000 -
regardless of how large the parameter is actually defined in the stored
procedure.
 
Back
Top