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]>
