cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nigel Shrieves <nshrie...@sportcentric.com>
Subject FIXED: Return value from Oracle Stored Procedure
Date Wed, 26 Feb 2003 14:30:56 GMT
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 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



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

Mime
View raw message