Ref cursor out parameter :: SQLTransformer

[Rui Alberto <ru...@ptinovacao.pt>]

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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org