Java Mailing List Archive

http://www.gg3721.com/

Home » user.groovy »

[groovy-user] Stored Procedure and Groocy SQL

James Hughes

2008-08-08

Replies: Find Java Web Hosting

Author LoginPost Reply
Hello,

Maybe I am an idiot but assuming I have a Stored Procedure,

GETSLA
(
  INSLACODE     IN VARCHAR2 ,
  INSWDATE     IN DATE   ,
  OUTDAYOFFSET   OUT NUMBER  ,
  OUTTIME      OUT VARCHAR2 ,
  OUTCHANGETIME  OUT VARCHAR2 ,
  OUTLOGCHECKMAX OUT NUMERIC
)

How do I actually call this and extract the out values from the call? I am not sure how to actually specify an out parameter and map it. HELP :-P

James



--------------------------------------------------------------------
This e-mail is intended solely for the addressee and is strictly confidential; if you are not the addressee please destroy the message and all copies. Any opinion or information contained in this email or its attachments that does not relate to the business of Kainos
is personal to the sender and is not given by or endorsed by Kainos. Kainos is the trading name of Kainos Software Limited, registered in Northern Ireland under company number: NI19370, having its registered offices at: Kainos House, 4-6 Upper Crescent, Belfast, BT7 1NT,
Northern Ireland. Registered in the UK for VAT under number: 454598802 and registered in Ireland for VAT under number: 9950340E. This email has been scanned for all known viruses by MessageLabs but is not guaranteed to be virus free; further terms and conditions may be
found on our website - www.kainos.com


---------------------------------------------------------------------
To unsubscribe from this list, please visit:

  http://xircles.codehaus.org/manage_email


©2008 gg3721.com - Jax Systems, LLC, U.S.A.