Thank you and Luca for your replies.
I'm getting closer to what I want now.
My problem now is processing the resultset from my stored procedure.
<esql:call><snip/>
<esql:call-results>
<esql:row-results>
<esql:get-columns/>
This works *only* if the driver will return a resultset with the call which is unlikely. Usually, the resultset is returned as out parameter which can then be casted to a resultset object.
From the docs:
| If a result set is returned through the (only) return parameter of a | stored procedure, e.g. resultset-from-object="1" as attribute to | <esql:call/>to automatically use this result set. For a more general | alternative see further below.
| <esql:call>{? = foo(<esql:parameter direction="in"
| type="Int"><xsp:expr>1</xsp:expr></esql:parameter>)}
| </esql:call>
| <esql:call-results>
| <esql:use-results>
| <esql:result><xsp:expr>(ResultSet)<esql:get-object column="1"
| from-call="true"/></xsp:expr></esql:result>
| <esql:results>
| <esql:row-results>
| <esql:get-string column="1"/>
| </esql:row-results>
| </esql:results>
| </esql:use-results>
| </esql:call-results>HTH
Chris.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
