cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From (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.


-----Ursprüngliche Nachricht-----
Gesendet: Mittwoch, 8. Januar 2003 13:48
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"
        <esql:parameter direction="in"
        <esql:parameter direction="out" type="Int"></esql:parameter>)} 

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) 
temp_int int; 
  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.     <>

To unsubscribe, e-mail:     <>
For additional commands, e-mail:   <>

View raw message