Quick way to change schema owner in PL/SQL code [message #37700] |
Thu, 21 February 2002 23:04 |
Nicola Farina
Messages: 63 Registered: October 2001
|
Member |
|
|
Hi all!
I am looking for a quick way to change schema owner in PL/SQL code.
For example: I have an application which uses three different schema-users. Anyone of these schema can contain stored procedure which reference objects in the others two schemas.
Each customer has different names for these three users...
The problem arises when I wrote some new stored procedure or pl/sql code and want to deploy this code to our customers. If the code contains an explicit reference (e.g. select from USER1.TABLE1) I need, each time, to replace the reference with the correct name for each client.
Which is the best way to parameterize (is it correct in english? I hope it is clear...) these user names?
TIA
Nicola
PS
The db is Oracle 8.i but even 7.3.4 in some cases.
|
|
|
|