ed 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://www.artfulsoftware.com
-
Anchan
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,
nk 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 func
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 a scalar. To return multiple values, use an sproc
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
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 serv
