Re: Return value from Oracle Stored Procedure

[Gabriele Domenichini]

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]