INSERT INTO EXEC

[Marc Schneider]

In SqlServer i have a meta database `MyBase` who consolid n databases `Base_i`
In each `Base_i` i have procedures like :

CREATE PROCEDURE myProc
@i int
AS
SELECT * FROM myTable WHERE (MyColumn < @i)
GO

But More complex of course and different in each `Base_i` !
For the consolidation i load this proc in each `Base_i` like :

CREATE PROCEDURE consolid
AS
DECLARE @isAProc varchar(150)
CREATE TABLE #myTemporary(
.....
)

-- for each `Base_i`
SET @isAProc = 'Base_i' + '..myProc'
INSERT INTO #myTemporary EXEC (@isAProc )
--end for each

INSERT INTO the_real_consolid_table SELECT * FROM #myTemporary WHERE ...
GO

In MySql 5.0.15 i can't do this ?
I try this ways in
SET @leExec = CONCAT('INSERT INTO `myTemporary`, .....);
PREPARE stm_str_sql FROM @leExec;
EXECUTE stm_str_sql;
DEALLOCATE PREPARE stm_str_sql;
but this is not good:
INSERT INTO `myTemporary` CALL
INSERT INTO `myTemporary` SELECT CALL

Then i try to do a function that RETURNS TABLE
it's not possible

How can i do my consolid whith out rewrite all procedures of `Base_i` in `MyBase`?