Stored procedure hangs

[-]

i have a problem with a stored procedure. It works when i insert a new
record but when i try to reinsert the same record again to test the "IF"
statement, the server hangs and lost connection.
CREATE PROCEDURE ....
(
IN p_id INT,
OUT p_status INT
)
BEGIN
IF (SELECT COUNT(*) FROM ... WHERE id = p_id) > 0 THEN
BEGIN
SET p_status = -1;
END;
ELSE
BEGIN
....
....
SET p_status = 1;
END;
END IF;
END;

[-]

nevermind. i solved it.
- wrote:

CREATE PROCEDURE ....
(
IN p_id INT,
OUT p_status INT
)

BEGIN

SET @count = 0;
SELECT COUNT(*) INTO @count FROM ... WHERE id = p_id;

IF (@count > 0) THEN
BEGIN
SET p_status = -1;
END;
ELSE
BEGIN
....
....
SET p_status = 1;
END;
END IF;
END;