Hello
I have a cocoon version number 2.0.3, a tomcat version number 4.0.16 and an Oracle 8i database
I have a store procedure in my database called sp_add_user.
I tested the store procedure manually and it doesn't have any problem. It has 3 parameters.
The first and the second are IN parameters, and must be String. The third is an OUT parameter and must
be integer.
The source of this page is
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsp:page
language="java"
xmlns:xsp="http://apache.org/xsp"
xmlns:xsp-request="http://apache.org/xsp/request/2.0"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
>
.
.
.
<esql:connection>
<esql:pool>mydb</esql:pool>
<esql:execute-query>
<esql:call>{call sp_add_user(<esql:parameter direction="in" type="String"><xsp-request:get-parameter name="username"/></esql:parameter>,
<esql:parameter direction="in" type="String"><xsp:expr>password</xsp:expr></esql:parameter>,
<esql:parameter direction="out" type="Int"></esql:parameter>)}
</esql:call>
<esql:results>
<esql:row-results>
<xsp:logic>
if(<xsp:expr><esql:get-int column="1"/></xsp:expr> == -1) {
<xsp:content>Sorry, user is ready registered</xsp:content>
} else {
<xsp:content>User added with key: <esql:get-int column="1"/>.</xsp:content>
}
</xsp:logic>
</esql:row-results>
</esql:results>
<esql:error-results>
<para>the following error occured: <esql:get-message/></para>
</esql:error-results>
<esql:no-results>
<para>problem with database</para>
</esql:no-results>
</esql:execute-query>
</esql:connection>
.
.
.
</xsp:page>
When I tried to load the page I have always this problem:
problem with database
<esql:no-results>
<para>problem with database</para>
</esql:no-results>
The source of stored procedure is:
PROCEDURE SP_ADD_USER(
name IN varchar2 default NULL,
pass IN varchar2 default NULL,
outer OUT NUMBER)
as
temp_Int int;
begin
temp_Int :=888;
outer := temp_Int;
/* select 888 into outer from DUAL; */
end SP_ADD_USER;
Please help me!!!!
Thank you!
Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht gestattet.
This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.