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 trying to write a function which returns multiple values.  I don't know if 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 version for the right syntax to use near '    
   integer,
   integer,                  ' at line 7
I have attached the function i am trying to create.  Please refer to the attached thread for contract related information.
 
I would appreciate if somebody can give me a call so that i can clear few other questions.
 
Thanks
Dinesh Anchan
212-231-7187


From: Pam Keen [mailto:pkeen@mysql.com]
Sent: Thursday, April 07, 2005 10:21 AM
To: Marcus, Jeff
Cc: Pisula, Mike; Pedersen, Mads; Mishkind, Scott; Anchan, Dinesh; robert.tas@247relamedia.com; 'Philip Antoniades'; 'Kenneth Moses'
Subject: RE: MySQL/24/7 Real Media support contract renewal

Jeff,
 
What is your availability to discuss/resolve the below and to discuss the Informix migration effort.  I am available early next week - Monday all day and Tuesday, late morning,early afternoon.  As an interim measure, I extended support till the end of this week for your team's development efforts.
 
Thank you,
 
Pam Keen
212 566 2714


No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.4 - Release Date: 4/6/2005