MySQL Forums
Forum List  »  Stored Procedures

Re: INSERT INTO EXEC
Posted by: Jay Pipes
Date: November 22, 2005 06:21PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2942
November 16, 2005 03:39AM
1779
November 16, 2005 04:59AM
1814
November 17, 2005 02:34AM
1887
November 17, 2005 03:05AM
1799
November 18, 2005 02:39AM
1989
November 18, 2005 06:08AM
1988
November 21, 2005 08:01AM
1769
November 21, 2005 08:14AM
1915
November 18, 2005 02:53AM
1997
November 22, 2005 01:59AM
1832
November 22, 2005 02:20AM
Re: INSERT INTO EXEC
2118
November 22, 2005 06:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.