存储过程

这个存储过程是嘛意思，帮忙解释下 ，俺想把他转换成mysql的存储过程不知道肿么写{:3_65:}

CREATE  procedure selectCmypTree(in parentID  integer)
DYNAMIC RESULT SETS 1  
p1 : BEGIN   
      DECLARE  bems_cmpy_tree_cursor CURSOR  WITH RETURN TO CLIENT  FOR   

WITH report( CMPYID, CMPYNAME ,  S_CMPYNAME ,IFLEAF,PID ,IFHEAT )  
AS  
(  
SELECT CMPYID, CMPYNAME ,  S_CMPYNAME ,IFLEAF , PID , IFHEAT
FROM tbl_web_company
WHERE PID =  parentID
  UNION ALL  
SELECT a.CMPYID, a.CMPYNAME ,  a.S_CMPYNAME ,a.IFLEAF,a.PID ,a.IFHEAT
FROM tbl_web_company a, report b  
WHERE a.PID = b.CMPYID
)  
SELECT CMPYID, CMPYNAME ,  S_CMPYNAME ,IFLEAF,PID ,IFHEAT  FROM report;  --
  OPEN bems_cmpy_tree_cursor ;   --
END p1;收起