Pushing stored procedure to a multisite database in WordPress

I am given a WordPress multisite and need to extract information from the site. I have written a stored procedure that recursively builds a tree relationship for posts of a certain kind. Now I am wondering how to push the stored procedure to the databases of all the sites.(Since this is a multisite configuration, each site(subdomain in this case) has a separate database.)

Please help me in this regard.

WordPress version: 3.5.1 Multisite config type: subdomains

//code needs refinement

DELIMITER //
CREATE PROCEDURE getPath(IN post_id INT, IN return_path TEXT)

BEGIN

 DECLARE done INT DEFAULT 0;
 DECLARE a INT;
 DECLARE b TEXT;
 DECLARE cur1 CURSOR FOR (SELECT * FROM TempTable112);     
 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
 DROP TABLE IF EXISTS TempTable112;

 SET max_sp_recursion_depth := 10;

 CREATE TEMPORARY TABLE TempTable112 AS SELECT id,post_title FROM wp_101_posts WHERE post_parent = post_id and post_status='publish'; 

SET @s = CONCAT('SELECT * INTO OUTFILE ',"'", CONCAT('Sample',FLOOR(1000+RAND()*9999)),'.txt',"'",' FROM TempTable112');
PREPARE stmt2 FROM @s;
EXECUTE stmt2;
DEALLOCATE PREPARE stmt2;

    OPEN cur1;

read_loop: LOOP
    FETCH cur1 INTO a,b;
    IF done = 1 THEN
      LEAVE read_loop;
    END IF;
         SET return_path = CONCAT('/',return_path,b);
     CALL getPath(a, return_path);
  END LOOP;
  CLOSE cur1;
END //

DELIMITER ;