OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Question on returning multiple rows from a stored procedure into a session variable

From: Vikram Vaswani (bacchusvsnl.com)
Date: Wed Dec 24 2008 - 10:23:21 CST


Hi

Is there a way to write a stored procedure that returns a result set
containing multiple rows? More specifically, I'm trying to return the
multi-row result set as an OUT parameter, which I can then access via a
session variable. If this is possible, could someone direct me to the
appropriate documentation or post an example. Thanks.

Vikram

--
Operator: "So what do you need? Besides a miracle."
Neo: "Guns. Lots of guns."
     -- The Matrix

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql