Re: Resolving strings to actual objects

On 2005-09-06, DA Morgan <damorgan_at_psoug.org> wrote:
> Rene Nyffenegger 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
>
> DBA_OBJECTS. But don't be surprised if it returns more than one.
> This sounds like a very bad idea.

Thanks for the suggestion.

I did some searching and using

  select object_name, procedure_name
  from dba_procedures
  where procedure_name like '%RESOLVE%';

I got

   OBJECT_NAME                    PROCEDURE_NAME
   ------------------------------ ------------------------------
   DBMS_UTILITY                   NAME_RESOLVE

which _seems_ to be what I needed.
I still have to verify my assumption, though.

Rene

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