Re: Please help - dependancies

A public synonym does never have the priority on the user own object. Suppose you have a public synonym EMP and a user A having it's own object EMP, then under user A the definition of object EMP always refer to the user's object.

So if EMP public synonym refer to a package and A.EMP refer to a table, the object EMP is a table for user A.

For the dependanecy, it depens under which user the procedure Query_Emp is definded.
If the Query_Emp belongs to A and you create an A.EMP table then the procedure will become invalid.

Hope it helps.
Alain.

Arthur wrote:

> Hi,
>
> Sorry for posting this twice, my previous post, I don't think I was
> obvious that I needed some help from the readers of this newsgroup.
> *smile*.
>
> I am going to sit for my exam soon and I am hoping someone would be
> able to help me with some of the questions I have from reading the
> text book, it's dealing with dependacies, Object.
>
> There's a procedure called Query_emp that dependant on a public
> synonym called EMP. Suppose later on, a table is created called EMP.
>
> a) Will this change invalid the procedure Query_emp ?
> b) Which of the two EMP object will the procedure refernce ?
>
> All help will be greatly appriciated.
>
> Arthur
Received on Tue Feb 13 2001 - 14:38:16 CST