Re: Resolving strings to actual objects

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 06 Sep 2005 17:50:08 -0700
Message-ID: <1126054177.382145@yasure>

Rene Nyffenegger wrote:

> 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

Also look at this:

SELECT object_name
FROM all_arguments
WHERE package_name =

Too if it might apply.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Tue Sep 06 2005 - 19:50:08 CDT