Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe command equivalent query
"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 Received on Tue Jun 22 2004 - 22:53:01 CDT