Re: Stored Procedure Returning Multiple Rows

[marc jeeves]

i Figured it out i need to use a procedure instead of a function

thanks

Madaxe

CREATE DEFINER=`root`@`localhost` PROCEDURE `test`(
IN `NumberOfObjectIDs` INT
)
LANGUAGE SQL
DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ''
BEGIN
DECLARE next_val int(11);
DECLARE i int;

CREATE TEMPORARY TABLE
IF NOT EXISTS
lekodata.TempTable (objectid int);

DELETE FROM lekodata.TempTable;

SET i = 0;

loop_loop: LOOP

SET i = i + 1;
IF i <= NumberOfObjectIDs THEN
INSERT INTO lekodata.TempTable SELECT lekodata.NextObjectID(1);
ITERATE loop_loop;
END IF;
LEAVE loop_loop;

END LOOP loop_loop;
SELECT OS.objectid FROM lekodata.TempTable OS;

END