cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: esql - oracle stored procedure returns resultset
Date Tue, 30 Jul 2002 17:42:51 GMT
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
haul@informatik.tu-darmstadt.de
    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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message