Re: Q: Pointers to ORACLE functions - Reply

> - 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