FIXED: Return value from Oracle Stored Procedure

2003-02-26 Thread Nigel Shrieves



Works 
if I change 
 

 
to
 

 
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:
   
     
  
   
     
  {call iauth_user_process.is_valid_authlogin(   
  p_authlogin,   
  p_authpassword,   
  p_clientipaddress,   
  p_secure,   
  p_session,   
  p_siteid,   
  )}   
  
   
     
        
   
     
  
   
  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
 


Return value from Oracle Stored Procedure

2003-02-26 Thread Nigel Shrieves



Cannot get a return 
value from the following:
 
   

 
   
{call iauth_user_process.is_valid_authlogin(   
p_authlogin,   
p_authpassword,   
p_clientipaddress,   
p_secure,   
p_session,   
p_siteid,   
)}   

 
   
      
 
   

 
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