aspose file tools*
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
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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Oracle9i wrong number or types of arguments in call to...