try the following:
<esql:execute-query>
<esql:call>
{call rptLocationDeviations(<esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}
</esql:call>
<esql:results>
<esql:row-results>
<test>
<!-- I'm not sure if this is correct,
because param 1 is the returned resultset.
use an explicit column name from your resultset
instead -->
<esql:get-string column="1"/>
</test>
</esql:row-results>
</esql:results>
</esql:execute-query>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
