Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Henry Lowell
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Henry Lowell
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, update: I've changed my code to the following...



And still getting the same error message.
 
Henry Lowell
Ranch Hand
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 63
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I had to change the way I was calling the stored procedure to:

begin GET_ACCT_TYPES(?); end;

And now it works.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic