Definitely today is not my day :) When trying to register an out parameter in SQLTransformer of type oracle.jdbc.driver.OracleTypes.CURSOR, an SQLException is thrown. Failed to execute pipeline.: java.sql.SQLException: Ref cursor is invalid (This happens while SQLTransfomer is executing:
Object obj = cst.getObject( counter.intValue() ); //Line 1286 I've already used SQLTransformer to fetch REF CURSOR out parameters without any problem! The most weird thing here is that I wrote a simple test class to execute the same stored procedure, and the execution completes without any problem (Execution succeeds also using SQL*Plus)! Does anyone here faced this problem or has any idea what's going wrong here?! Cocoon : 2.1.7 JDK : 1.5.0_02 Tomcat : 5.5.7 Database: Oracle 9.2.0.4.0 Thanks to all, Rui --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
