Re: Problem getting result set from Oracle stored procedures

[Gildas Guillemot]

Martin Rusnak a �crit :
Hello all,

I am trying to get result set from a stored procedure (function)
in Oracle database, using Cocoon 2.1 ESQL. My working Java code
looks like the following:
CallableStatement cstmt = conn.prepareCall("{?=call sp_resultset()}");
cstmt.registerOutParameter(1,OracleTypes.CURSOR);
cstmt.execute();
ResultSet rs = (ResultSet)cstmt.getObject(1);
I tried to use esql:call element with the @resultset-from-object
attribute, but the page processing failed with LanguageException.
Here is the XSP code snippet I used:
<esql:execute-query>
    <esql:call resultset-from-object="1">{?=call 
sp_resultset()}</esql:call>
Have you tried with this synthax here  (removing the "call"):
<esql:call resultset-from-object="1">{?= sp_resultset()}</esql:call>
    <esql:call-results>
        <esql:row-results>
            <row>
            <esql:get-columns/>
            </row>
        </esql:row-results>
    </esql:call-results>
</esql:execute-query>
[...]

--
Gildas


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]