On 30.Jul.2002 -- 04:34 PM, Frank Taffelt wrote: > > 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).
I'm certain that others do use oracle sps the way described. Actually, the esql sp support started that way... Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- 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]>