On 07.Jan.2003 -- 03:46 PM, [EMAIL PROTECTED] wrote: > Hello > > I have a cocoon version number 2.0.3, a tomcat version number 4.0.16 and an > Oracle 8i database
Cocoon 2.0.4 is released and fixes a number of bugs and Tomcat 4.1.18 is out containing security related fixes. > 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 > <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> > Now, since your SP apparently does not return a result set, you need to use <esql:call-results> instead. This is executed regardless of a result set. Without a result set, there are no row-results. So... > <xsp:logic> > if(<xsp:expr><esql:get-int column="1"/></xsp:expr> == > -1) { And since your SP does not return a result set, you need to add the attribute 'from-call="yes"' to the <esql:get-int/> tag. > > <xsp:content>Sorry, user is ready > registered</xsp:content> > } else { > > <xsp:content>User added with key: <esql:get-int > column="1"/>.</xsp:content> dito > } > </xsp:logic> </esql:call-results> > > <esql:error-results> > <para>the following error occured: <esql:get-message/></para> > </esql:error-results> > This does not work here: > <esql:no-results> > <para>problem with database</para> > </esql:no-results> > > </esql:execute-query> > </esql:connection> > > . > . > . > > </xsp:page> Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>