You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Nigel Shrieves <ns...@sportcentric.com> on 2003/02/26 15:14:12 UTC
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
Re: Return value from Oracle Stored Procedure
Posted by Gabriele Domenichini <ga...@fastmail.fm>.
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: cocoon-users@xml.apache.org
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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org
Re: Return value from Oracle Stored Procedure
Posted by Gabriele Domenichini <ga...@fastmail.fm>.
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: cocoon-users@xml.apache.org
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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org