I know it sounds kind of silly of me, but, wouldn't it be easier if you just made the base_i stored procedures insert into the temporary table instead of returning a resultset? Then, instead of the inefficient stored procedure cursor and dynamic CALL statement building you're attempting, do that in a scripting language like Perl, Python, PHP, etc...
Then, after running the "base_i" procedures, simply execute one stored procedure that inserts the temp table as a whole into the consolidated table.
Then again, if you go through that much trouble, why not just use a MERGE table?
Jay Pipes
Community Relations Manager, North America, MySQL Inc.
Got Cluster?
http://www.mysql.com/cluster
Personal:
http://jpipes.com