Help with calling an Oracle 9i Stored Procedure

Originally Posted by mlotspe

I've got a problem calling a Oracle 9i Stored Procedure. Here's a code snippet of what I'm doing.

Here's the Oracle 9i function variable description:

(Result) BOOLEAN
ID1 Number(9) IN
ID2 VarChar2 IN
BillRec RECORD IN OUT
ErrCode VarChar2 IN OUT
ErrMSG VarChar2 IN OUT

Here's my Java Code:

CallableStatement pstmt = conn.prepareCall("{?=call MyFunction(?,?,?,?,?,?)}");


pstmt.registerOutParameter(1,OracleTypes.BOOLEAN);
pstmt.setLong(2, ID1); // input parameter
pstmt.setString(3, ID2); // input parameter


pstmt.registerOutParameter(4,OracleTypes.CURSOR);
pstmt.registerOutParameter(5,Types.CHAR);//error code
pstmt.registerOutParameter(6,Types.CHAR);//error message
pstmt.executeQuery();

The error is 1008ORA-01008: not all variables bound

I've tried many variations and the error messages vary. But the above seems the most logical syntax to me but evidently, wrong.

Any help would be greatly appreciated as I'm really stumped!!