I am trying to call this procedure using cocoon. getLoginResult. This
stored procedure takes 2 strings and returns an int. My code is below
but I am getting an error of incorrect syntax near {. I have tried
literally hundreds of different combinations with nothing working can
someone please show me the light?
<esql:connection>
<esql:pool>vyzo</esql:pool>
<esql:execute-query>
<esql:call>
{ getLoginResult (<esql:parameter direction="in"
type="String"><xsp:expr>user</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>password</xsp:expr></esql:parameter>)}
</esql:call>
<esql:results>
<esql:row-results>
<data>
<xsp:logic>
login = <esql:get-int column="1"/>;
</xsp:logic>
</data>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
Thank you
Tim
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
