Re: Executing stored procedures of another schema

Hi!

I fail to understand one imp. point here. If you are UserB and are using ProcA,procA cannot access TableA(of Diff User) unless there is an explicit reference(username.tablename) to that table.If so, try to remove that username ref. Also, how can you have access to two different objects with the same name? Oracle will not allow it. You can use Decode statement to pick out the table you want depending upon the user, however, I now think it is not effective to your situation as this can be solved lot more simpler. Thanks.

-Kumar.

> Thank you!
> I forgot one detail in the description of my problem: tableA in userA
> and tableB in userB have the same name. When I call procA from userA, it
> uses the data in userA's instance of the table. The problem is that when
> I call procA from userB, it still uses the data in userA's instance of
> the table. So I wonder if there is a method to use a single stored
> instance of procA on multiple users, each with her own instance of a
> table with same name and different data.
> Can you still give me any hints or detail the use of decode statement
> for my problem?
> --
> Piero Stanchi - Consultant for Pharmacia & Upjohn
> Voice: +39 2 48384265 - Email: piero.stanchi_at_eu.pnu.com
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 18:00:27 CDT