Re: help calling procedure in package from different users
Date: Tue, 29 Jan 2008 20:04:50 +0100
> thanks. This seems to work for everyone:
> create public synonym testsynonymn for user1.package1
> begin testsynonym.procedure1(args); end;
> Anyone have any other suggestions as this would require the creating
> of a massive number of synonyms?
- automate the synonym creation (write a script, that delivers the correct statement)
- rethink you strategy of having so many users, that all own a couple of procedures. It is far more customary to have one or two users that "own" the application: data, procedures, etc.
-- Regards, Frank van Bortel Top-posting in UseNet newsgroups is one way to shut me upReceived on Tue Jan 29 2008 - 13:04:50 CST