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

Reply via email to