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

[Henry Lowell]

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:

CallableStatement cStmt = con.prepareCall("{call GET_ACCT_TYPES}");
cStmt.registerOutParameter(1, Types.VARCHAR);
cStmt.registerOutParameter(2, Types.VARCHAR);
ResultSet rs = cStmt.executeQuery();
while(rs.next())
{
   System.out.println(rs.getString("ACCT_TYPE_NAME"));
}

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]

Ok, update: I've changed my code to the following...

CallableStatement cStmt = con.prepareCall("{ call ? := GET_ACCT_TYPES() }");
cStmt.registerOutParameter(1, OracleTypes.CURSOR);
cStmt.execute();
ResultSet rs = (ResultSet)cStmt.getObject(1);
while(rs.next())
{
   System.out.println(rs.getString("ACCT_TYPE_NAME"));
}

And still getting the same error message.

[Henry Lowell]

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]

I had to change the way I was calling the stored procedure to:

begin GET_ACCT_TYPES(?); end;

And now it works.