cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From michael.raffenb...@t-online.de (Raffy)
Subject AW: Return value from Stored Procedure
Date Wed, 08 Jan 2003 13:47:15 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message