Return value from Stored Procedure

[Ig...@pass-consulting.com]

Please, can you give me an example,
how can i get the return-value of 3. "OUT"-parameter here:

<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>userpass</xsp:expr></esql:parameter>,
	<esql:parameter direction="out" type="Int"></esql:parameter>)}
</esql:call>


I have always "no results", but my Stored Procedure returns always 888:

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;
end sp_add_user;

I use Oracle 8, Tomcat 4.0.16 and Cocoon 2.0.3.

This is very important and i cannot find anything in internet about it.
Thank you very much!
Best regards.


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.

AW: Return value from Stored Procedure

[Raffy <mi...@t-online.de>]

Hi Igor, 

try something like this:
<esql:get-string from-call="true" column="1"/>

Hope this helps.

Raffy

-----Ursprüngliche Nachricht-----
Von: Igor.Kozlov@pass-consulting.com
[mailto:Igor.Kozlov@pass-consulting.com] 
Gesendet: Mittwoch, 8. Januar 2003 13:48
An: cocoon-users@xml.apache.org
Betreff: Return value from Stored Procedure


Please, can you give me an example, 
how can i get the return-value of 3. "OUT"-parameter here: 
<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>userpass</xsp:expr></esql:parameter>, 
        <esql:parameter direction="out" type="Int"></esql:parameter>)} 
</esql:call> 


I have always "no results", but my Stored Procedure returns always 888: 
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; 
end sp_add_user; 
I use Oracle 8, Tomcat 4.0.16 and Cocoon 2.0.3. 
This is very important and i cannot find anything in internet about it. 
Thank you very much! 
Best regards. 


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.


---------------------------------------------------------------------
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:     <co...@xml.apache.org>
For additional commands, e-mail:   <co...@xml.apache.org>