Home » SQL & PL/SQL » SQL & PL/SQL » Quick way to change schema owner in PL/SQL code
Quick way to change schema owner in PL/SQL code [message #37700] Thu, 21 February 2002 23:04 Go to next message
Nicola Farina
Messages: 63
Registered: October 2001
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?
The db is Oracle 8.i but even 7.3.4 in some cases.
Re: Quick way to change schema owner in PL/SQL code [message #37705 is a reply to message #37700] Fri, 22 February 2002 03:42 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
if u create public synonyms then u dont need to prefix username to object.
Previous Topic: text file and pl/sql relation
Next Topic: Select records within a range from a BIG table
Goto Forum:

Current Time: Fri Sep 17 03:16:41 CDT 2021