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: Problem getting result set from Oracle stored procedures
Date Fri, 05 Sep 2003 13:11:26 GMT
On 05.Sep.2003 -- 02:11 PM, Martin Rusnak wrote:
> Here is full source of the page:
> 
> <?xml version="1.0"?>
> <xsp:page language="java"
> 	xmlns:xsp="http://apache.org/xsp"
> 	xmlns:esql="http://apache.org/cocoon/SQL/v2">
> <rowset>
> <esql:connection>
>   <esql:pool>oracle-connection</esql:pool>
>   <esql:execute-query>
>     <esql:call resultset-from-object="1">{?=call sp_test()}</esql:call>
>     <esql:call-results>
>       <esql:row-results>
>         <row>
>           <esql:get-columns/>
>         </row>
>       </esql:row-results>
>     </esql:call-results>
>   </esql:execute-query>
> </esql:connection>
> </rowset>
> </xsp:page>

Processing of @resultset-from-object has been broken. I've updated CVS
just now. Please update and verify. Anyway, you will still need to
enclose the result with esql:results. Apart from that, you may use

<esql:call>....</esql:call>
<esql:call-results>
 <esql:use-result>
   <esql:result><xsp:expr>(ResultSet)<esql:get-object from-call="true" column="1"/><xsp:expr></esql:result>
   <esql:results>
   ...
   </esql:results>
 </esql:use-result>
</esql:call-results>
  
Which is a little more verbose but IMHO preferable to the
@resultset-from-object syntax.

see http://cocoon.apache.org/2.1/userdocs/xsp/esql.html

	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

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message