In case anyone has the same problem.

BEA OEMs the driver from DataDirect. Here is knowledge base article on
the data direct website:,oracle

It looks like the version of DqtaDirect driver that ships with WLS 8.1
SP2 has this bug.
================================================== ===============
User is trying to execute a stored procedure which returns a refcursor.
When testing the Connect JDBC driver version 3.0.0000, the stored
procedure executes. When testing the latest 3.1 build, 3.1.0006, their
stored procedure returned the error message

Message: [DataDirect][Oracle JDBC Driver][Oracle]ORA-06550: line 1,
column 7:
PLS-00306: wrong number or types of arguments in call to ' procedure name>'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Vendor: 6550
State: HY000

The problem is reproduced when connecting to an Oracle 8.1.7 server.
It was introduced in the Connect JDBC driver build 3.0.0007. According
to the file which comes with the 3.0.0007 build we
deprecated the refCursorSupport connection property. This could be
related to the driver not being able to execute a stored procedure
containing ref cursors.


Driver was fixed in the Connect JDBC 3.1 Oracle driver version 3.1.0008