this is a snippet which works for me under mssql (jtds driver):
<esql:call>
{call proc_info(
<esql:parameter
type="Int"><xsp:expr>Integer.parseInt(id)</xsp:expr></esql:parameter>
)}
</esql:call>
<esql:results>
<esql:row-results>
...
</esql:row-results>
</esql:results>
i'm remembering problems with the positioning of "{" and the following
"call" keyword. You have to make sure that there is no space between them.
I'm not sure if this a jdbc driver issue or strictly enforced by jdbc, but
this drived my crazzy.
hth,
Frank
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
