Has anyone attempted to use jdbc drivers to access an Oracle StoredProcedure return a CURSOR or pl/sql Table datatype??? I'm trying to access using the OracleType.CURSOR as technet.oracle.com implies you can. But, for some reason I get an exception saying that I can't set an out parameter as CURSOR without getting an exception on the executeQuery command. Any thoughts?
This sounds a lot like you are connecting to a 7.x or earlier Oracle database. Previous to 8i, Oracle did not support returning a cursor from a stored procedure, If you are connecting to 8i and the stored procedure returns a cursor, you can try setting the return type as Types.OBJECT then cast it to a ResultSet object. (In my experiance with the Oracle packages, they have a lot of unresolved errors, so I try to stay with the java.sql package)