> > 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
