Return value from Oracle Stored Procedure

[Nigel Shrieves]

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 7

 

Regards

 

Nigel

 

 

 

---
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