Store Procedures

------=_NextPart_000_000E_01C58E14.C0595FE0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: 7bit

Hey,

Does anyone know how you set result sets in stored procedures? I want to
be able to do something like this:



Delimiter $

create procedure update()

BEGIN
RESULTSET = select * from DD

//Now do something here with this stored procedure
END$
call update ()$





_____

Enda Dowling

Software Engineer

Sentenial Ltd



Phone: +353 (1) 629 2406

Fax: +353 (1) 6292147

Mobile: 086 1944224

email: enda.dowling@sentenial.ie

web: www.sentenial.ie



_____

Notice:
The information in this e-mail is intended only for the named recipient and
may be privileged or confidential. If you are not the intended recipient,
please notify us immediately and do not copy, distribute or take any action
based on this e-mail. Sentenial Ltd will not be liable for direct, special,
indirect or consequential loss as a result of any virus being passed on or
arising from alteration of the contents of this e-mail by a third party. All
e-mail sent to or from this address is subject to archive and review by
someone other than the intended recipient. Any opinions expressed in this
e-mail are those of the individual and not necessarily those of Sentenial
Ltd. All Personal Data acquired by Sentenial Ltd for which the Data
Protection Act 1998 ("the Act") applies shall be stored and processed in
accordance with the Act. Should you wish to check, amend or remove the
details of your Personal Data held by Sentenial Ltd, please contact us at
info@sentenial.ie.






------=_NextPart_000_000E_01C58E14.C0595FE0--