Hi,
I have had success generating and executing stored procedures in the MySQL Developer application except for when my stored procedure has an out param defined.
I get a popup saying "Value does not fall within expected range." If I take out the OUT param, it works. Unfortunately I need to get the unique ID for the row inserted.. If I execute this stored procedure from another program (DBTools Manager) it works fine...
What am I doing wrong, here's how the stored procedure looks in your IDE.
PROCEDURE `db_scribbles`.`sp_CreateAuthor`(IN p_firstname VARCHAR(50), IN p_surname VARCHAR(50), IN p_personal_webpage LONGTEXT, IN p_biography LONGTEXT, IN p_picture TINYINT, OUT id INTEGER)
SQL SECURITY INVOKER
COMMENT 'Create an author'
BEGIN
INSERT INTO tbl_author VALUES(NULL, p_firstname, p_surname, p_personal_webpage, p_biography, p_picture);
SET @id = @@IDENTITY;
END
Thanks
Emma Middlebrook