Works
if I change
<esql:get-string
column="7"/>
to
<esql:get-int
column="7"/>
Must
be testing what the return type is as we use this same stored procedure in PHP
and it returns a string
######################Cannot get a return value from the following:<esql:execute-query><esql:call>{call iauth_user_process.is_valid_authlogin(
<esql:parameter direction="in" type="String"><xsp:expr>p_authlogin</xsp:expr></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>p_authpassword</xsp:expr></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>p_clientipaddress</xsp:expr></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>p_secure</xsp:expr></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>p_session</xsp:expr></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>p_siteid</xsp:expr></esql:parameter>,
<esql:parameter direction="out" type="String"/>)}
</esql:call><esql:call-results>
<esql:get-string column="7"/>
</esql:call-results></esql:execute-query>The error log is:org.apache.avalon.framework.CascadingRuntimeException: Error getting ascii data for column 7RegardsNigel
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03