469,275 Members | 1,871 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,275 developers. It's quick & easy.

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

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
Jul 21 '05 #1
2 12903
Pial <zi****@gmail.com> wrote:
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.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too
Jul 21 '05 #2
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.

Pial wrote:
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

Jul 21 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Michael Hogan | last post: by
reply views Thread by Rama krishna | last post: by
1 post views Thread by windos | last post: by
3 posts views Thread by bangaw | last post: by
reply views Thread by sonuindia88 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.