cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Rusnak <martin.rus...@voipac.com>
Subject Re: Problem getting result set from Oracle stored procedures
Date Mon, 08 Sep 2003 12:47:39 GMT
 >
 > 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>
 >

Finally I used that approach, but I encountered another bug in esql.xsl. There is no
matching prarenthesis on line 1007:

     _esql_query = _esql_query.newInstance((ResultSet) <xsl:apply-templates select="esql:result/*"/>));

After fixing the problem, the query runs successfully. Here is complete 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>{<esql:parameter direction="out" type="oracle.jdbc.driver.OracleTypes.CURSOR"/>=call
sp_test()}</esql:call>
<esql:call-results>
   <esql:use-results>
     <esql:result><xsp:expr>(ResultSet)<esql:get-object from-call="true" column="1"/></xsp:expr></esql:result>
     <esql:results>
       <esql:row-results>
         <row>
         <esql:get-string column="1"/>
         </row>
       </esql:row-results>
     </esql:results>
   </esql:use-results>
</esql:call-results>
</esql:execute-query>
</esql:connection>
</rowset>
</xsp:page>


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


Mime
View raw message