Hi,
I am trying to write a function which returns multiple
values. I don't knowif this is allowed or not but i am not able to
create this function. I get the following error:
ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in
the calling code after the sproc has executed.
Peter Brawley
http://www.artfulsoftware.com
-
Anchan, Dinesh wrote:
Hi,
I am
function;
Thank you for your help
Dinesh
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 12:24 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in the
calling code after the sproc has executed.
Peter
PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 07, 2005 4:03 PM
To: Anchan, Dinesh
Cc: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: RE: Need help in Stored procedures and functions
Anchan, Dinesh [EMAIL PROTECTED] wrote on 04/07/2005
03:44:07 PM:
Peter,
Thank you for your reply
Cc: mysql@lists.mysql.com
Subject: Re: Need help in Stored procedures and functions
Dinesh,
A stored func returns a scalar. To return multiple values, use an sproc
declaring the INOUT variables you need, pick up their values in the
calling code after the sproc has executed.
Peter Brawley
http