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

[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

 

[Jon Skeet [C# MVP]]

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 "

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.

 

[Joshua Flanagan]

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.