Hi Igor, try something like this: <esql:get-string from-call="true" column="1"/>
Hope this helps. Raffy -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 8. Januar 2003 13:48 An: [EMAIL PROTECTED] 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: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
