Author Login
Post Reply
Hi,
I am new to groovy and rite now working in a groovy project. I have been
stuck up with calling a stored procedure from groovy code. I am able to run
the stored procedure but not able to retreive the output from th stored
procedure. i am working on this issue for more than two days. I would be
grateful if any could help me out.
My code is
def row = sql.execute("{call Web_User_Insert(?,?,?,?,?,?,?,?,?,?)}",
[webuser.firstName,webuser.lastName,
webuser.username,
webuser.password,webuser.emailAddress,0,0,0,lastInsertId,failureCode])
I am able to run the code and changes are reflected. But my question is when
i run this procedure i need to get back two outputs lastInsertId and failure
code.
please help me out.
Thanks.
--
Sent from the groovy - user mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list, please visit:
http://xircles.codehaus.org/manage_email