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]>
