I can give you a really humble help: try use a get-object instead of get-string. Maybe your out parameter contains something not interpreted. A second suggestion: I have struggled with xml content and at the end we've found in the group that you must do something like this:
<esql:execute-query> <esql:call>{call your stored procedure}</esql:call> <esql:call-results> <util:include-expr> <util:expr> <esql:get-object column="7" from-call="true"/> </util:expr> </util:include-expr> </esql:call-results> <esql:error-results> <esql:get-message/> <esql:get-stacktrace/> </esql:error-results> </esql:execute-query> This only if your content is xml of course but maybe that's not the case.. ----- Original Message ----- From: Nigel Shrieves To: [EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 3:14 PM Subject: Return value from Oracle Stored Procedure 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]