File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies 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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
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
VARRAY is Stored Proc out param, throws exception ORA-06550
Can a oracle Stored procedure return a cursor as a return value?
Calling a function vs a procedure on Oracle with CallableStatement