Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Q: Pointers to ORACLE functions - Reply

Re: Q: Pointers to ORACLE functions - Reply

From: NEON Systems <neon_at_BGA.COM>
Date: Sun, 31 Dec 1995 15:21:26 -0600
Message-Id: <9512312125.AA25011@alice.jcc.com>


> - Is there a table in the catalogue that is exclusively dedicated to
> all the functions you can use in ORACLE??

sys.objects (user_objects and all_objects are useful views) do a select where object_type = 'PROCEDURE' or object_type = 'FUNCTION'. Note that in keeping with the Oracle philosophy about tables (all_catalog), you will only get objects that the user is allowed to execute using user_objects (and that the user is able to see using all_objects).

> - Is the table ARGUMENT$ the correct and only one to find infos about
> the functions. (We doubt it.)

This table is useful for argument info. There is another table with source definition (all_source) and a few others (procedure$).

sys.dbms_describe.describe_procedure() is a reasonable PL/SQL front-end to the argument$ table. odessp() is a good OCI front-end to the PL/SQL procedure.

Hope that helps Lothar.

Happy New Year.

Omri. Received on Sun Dec 31 1995 - 16:25:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US