> So you need to return a cursor as first parameter and use > @resultset-from-object="1"
yes but the to code to achive this is oracle dependent: IMHO code to achive this should look like: 1 CallableStatement cstmt = conn.prepareCall(query); 2 cstmt.registerOutParameter(1,OracleTypes.CURSOR); 3 cstmt.execute(); 4 ResultSet rset = (ResultSet)cstmt.getObject(1); the problem is line 2 which uses OracleType.CURSOR and no standard jdbc type . i think this code is not suitable for esql-logicsheet or ist it ? without registering the cursor the oracle driver assumes a different signature for the procedure and therefore cannot find it (this explains the error from my last try). so i think it's not yet the time for a summary ... P.S. i'm not that jdbc-oracle-expert maybe somebody has a solution for this --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
