How to do a SELECT on a Stored Procedure

Nagashree · #1 (**permalink**) 03-29-11, 04:01

DELIMITER $$
create procedure `test`(a number,b number)
begin
DECLARE result;
set result=a+b;

END $$
DELIMITER

SELECT * from test(1,2);

Output should be 3
Here "test" is the name of the procedure. How to do this on MYSQL?? This works in SQL Server, but not on MYSQL.
I get 1064(42000) error in the line -SELECT * from test(1,2);

it-iss.com · #2 (**permalink**) 03-29-11, 04:42

The closest you can get to what you are trying to do is creating a function rather than a procedure:

Code:

CREATE FUNCTION test(a DECIMAL,b DECIMAL)
RETURNS DECIMAL
NO SQL
BEGIN
	RETURN a+b;
END;
$$

Call the function you would issue:

Code:

SELECT test(1,4);

Harisankar.A · #3 (**permalink**) 05-27-11, 08:38

In MySQL Syntax to call procedure is,

CALL procedure_name();

In your case CALL test(1,2);

Internet Services

Web Development

Digital Marketing

Consumer Tech