MySQL Forums
Forum List  »  Stored Procedures

Dyanmic DB Name?
Posted by: adam perkins
Date: March 25, 2012 08:32AM

Hi There,

I have some very complex stored procedures which manipulate a lot of data in a single tenant DB environment. I could have 10 or 100 or 1000 separate databases/clients.
These stored procedures may have to run on any number of these databases at any given time.

Is there an efficient way to have a single copy of a stored procedure run against various client databases? Write these complex procedures completely in dynamic SQL isn't an option.

I was curious if there is a way to only change which DB the stored procedure points to, a method to roll out SP changes to each database, or some other solution I've not thought of.

Thank you for any help.
Adam

Options: ReplyQuote


Subject
Views
Written By
Posted
Dyanmic DB Name?
1629
March 25, 2012 08:32AM
740
March 25, 2012 09:40AM
827
March 26, 2012 10:47AM


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.