Re: Describe command equivalent query

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 23 Jun 2004 17:27:47 -0700
Message-ID: <1088036895.411519@yasure>

SRevale wrote:

> "Bagieta" <bagieta21_at_poczta.onet.pl> wrote in message news:<caor5l$aok$1_at_news.onet.pl>...
>

>>SELECT OBJECT_NAME, OBJECT_TYPE, STATUS
>>            FROM SYS.ALL_OBJECTS
>>            WHERE OBJECT_TYPE IN ('FUNCTION', 'PROCEDURE', 'TRIGGER',
>>'PACKAGE')
>>            AND OWNER = 'OWNER_NAME'
>>
>>Best regards
>>Bagieta
>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
>>dbDeveloper - Multiple databases editor
>>
>>http://prominentus.com
>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

>
>
> Thanks Daniel and Bagieta for your answers. But if its not what i'm
> looking for. If you take a look to the xxx_objects views, you'll see
> that PACKAGE definitions are not describe here, it's just the name.
>
> What i need to retrieve are the inside procedures and functions of the
> PACKAGEs. So, what i'd mentioned on my previous post was that if a
> procedure of a package doesn't have arguments, it's not shown.
>
> I asked for and equivalent of the DESCRIBE command 'cause it looks to
> fast for parsing the PACKAGE body from the xxx_source view. Thats why
> I think there should be another way. Maybe with OCIs, i don't know.
>
> Well, thanks again, and I still wait for that answer.
> I know is out there.
>
> Santiago

desc <object_name>

SELECT object_name, argument_name, data_type, default_value, in_out FROM all_arguments
WHERE package_name = <package_name>
ORDER BY object_name, position;

Go http://www.ca.com and order a copy of their data dictionary poster. If you can't find it there send a donation large enough to cover postage to the Puget Sound Oracle Users Group and I will send you one. http://www.psoug.org

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed Jun 23 2004 - 19:27:47 CDT