Function 템플릿

delimiter $$

DROP FUNCTION IF EXISTS getVMwareIPAddress$$

CREATE FUNCTION `getVMwareIPAddress`(

`p_guest_id` int

)

RETURNS varchar(500)

BEGIN

DECLARE done INT DEFAULT FALSE;

DECLARE temp_ip_address varchar (500);

DECLARE result_ip_string varchar (500);

END

$$

delimiter ;