my dog learned polymorphism*
The moose likes JDBC and the fly likes Oracle9i wrong number or types of arguments in call to... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Oracle9i wrong number or types of arguments in call to..." Watch "Oracle9i wrong number or types of arguments in call to..." New topic
Author

Oracle9i wrong number or types of arguments in call to...

Henry Lowell
Ranch Hand

Joined: May 29, 2006
Posts: 63
I am using the ojdbc14.jar thin driver. I have a Stored Procedure that takes no in parameters and return 2 out parameters. I have the following code:



I get the following exception:


java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_ACCT_TYPES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

I realize this may be difficult to troubleshoot since I can't show the actual stored procedure, but any help would be appreciated.

Thanks.


Hank
Henry Lowell
Ranch Hand

Joined: May 29, 2006
Posts: 63
Ok, update: I've changed my code to the following...



And still getting the same error message.
Henry Lowell
Ranch Hand

Joined: May 29, 2006
Posts: 63
Ok, well, it is not my java code. At least not yet. I get the same error running the query in SQL+. I'll update when I figure it out.
Henry Lowell
Ranch Hand

Joined: May 29, 2006
Posts: 63
I had to change the way I was calling the stored procedure to:

begin GET_ACCT_TYPES(?); end;

And now it works.
 
Don't get me started about those stupid light bulbs.
 
subject: Oracle9i wrong number or types of arguments in call to...
 
Similar Threads
Run dynamic sql in stored procedure problem
help:java.sql.SQLException: ORA-06550
Can a oracle Stored procedure return a cursor as a return value?
VARRAY is Stored Proc out param, throws exception ORA-06550
Calling a function vs a procedure on Oracle with CallableStatement