RAJESHKS wrote:
>
> Hi ,
>
> I would like to get some information regarding Schemas and PL/SQL Stored
> Procedures.
>
> I have two schemas S1 & S2 created. A table T1 is created on S1 and S2. I have
a
> stored procedure SP1 which is created under schema S1. S2 has the EXECUTE
> privileges on this stored procedure (S1.SP1). This stored procedure (S1.SP1)
> does a select from table S1.T1.
>
> Here is the question :
>
> When SP1 is executed from Schema S1, it should select from S1.T1 and when it
is
> executed from Schema S2, it should select from S2.T1. How can I achieve this ?
>
> A straightforward way of achieving this is by duplicating the stored procedure
> in both the schemas. This leads to storage space overhead which is not
> desirable. Is there some other solution ?
>
> Thanks
> Devadas
Use synonyms.
Received on Sun Feb 18 1996 - 11:04:04 CST
