/*------------------------------------------------------------------
  Creating a very simple hello_proc(string) procedure
------------------------------------------------------------------*/
DROP PROCEDURE hello_proc;
/

CREATE PROCEDURE hello_proc( IN p_name varchar(20) )
BEGIN
-- ==========================
-- Param: p_name varchar(20)
-- ==========================
    SELECT 'Hello ', p_name;	        --display multiple items
END;
/

CALL hello_proc('sam');