Re: One set of stored procedure for multiple users

You may be able to do something with this idea.

Create your N sets of data, each in their own 'client' schema. Create an empty 'support' schema.

In the support schema, create one set of views like:

   create or replace view XYZ as select * from client1.XYZ;

using a script that allows you to supply a client schema as an input parameter.

Create all the packages in the support schema.

When you need to do some support work for another client, execute the view-creation script with the new client as the input parameter.

When you redefine the views, all the packages will become invalid, but should automatically re-compile as needed.

This won't work if you have to run material for more than one client at a time though.

---
Jonathan Lewis.