aspose file tools
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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.
 
 
subject: Oracle9i wrong number or types of arguments in call to...