Re: Resolving strings to actual objects

On 2005-09-08, Jaap W van Dijk <j.w.vandijk.removethis_at_hetnet.nl> wrote:
> On Tue, 6 Sep 2005 23:32:37 +0000 (UTC), Rene Nyffenegger
><rene.nyffenegger_at_gmx.ch> wrote:
>
>>Hello
>>
>>Is someone aware of a dbms_ package, a dba_ view or
>>anything that I can use to resolve a string to
>>an actual object.
>>
>>I face the problem that I have some string, for example
>>FOO.
>>
>>Now, someone might have set a public synonym for FOO
>>to point at SOMEONE.BAR. I'd like this function, view
>>or whatever to return SOMEONE.BAR if I give it the string
>>FOO.
>>
>>Also, FOO might be a _real_ object, not a synonym, in
>>which case I'd like that mechanism to return
>>RENE.FOO (RENE being the username with which I am
>>logged into Oracle).
>>
>>Version 9i or 10g.
>>
>>
>>Thanks,
>>Rene
> How about writing a recursive function?

Yes, why not? I think I'd be capable of doing exactly that. Yet, I hope that there is a re-usable thing already provided by Oracle. And also, I think I am not the only one who wants such a function. Anyway, dbms_utility.name_resolve really looks promising, but I still haven't found the time to look into it thoroughly.

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/