listing funcs and procs

#1

Hi, anyone have code snippets on how to list out user functions and
procedures? perhaps there is a table or view that contains
this information, like user_procs or user_funcs or something like that.
Thanks,
Sean

#2

"seannakasone" <snakason (AT) flex (DOT) com> a écrit dans le message de news:
Pine.CYG.4.58.1004010942240.2888 (AT...naryrpgevp.arg...

Quote:

Hi, anyone have code snippets on how to list out user functions and
procedures? perhaps there is a table or view that contains
this information, like user_procs or user_funcs or something like that.
Thanks,
Sean

user_objects and choose object_type
user_source for the code
user_errors for the compilation errors
user_arguments for the procedure arguments

Regards
Michel

#3

that's what i needed. thankyou!!

#4

On Apr 1, 3:45*pm, seannakasone <snaka... (AT) flex (DOT) com> wrote:

Quote:

Hi, anyone have code snippets on how to list out user functions and
procedures? *perhaps there is a table or view that contains
this information, like user_procs or user_funcs or something like that.
Thanks,
Sean

Beides looking in dba_objects and dba_arguments as Michel mentioned
there is another view that may be of interest: all_procedures

It can be used to identify if the procedure is pipe_lined, aggregate,
etc ....

HTH -- Mark D Powell --

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

listing funcs and procs

comp.databases.oracle.misc comp.databases.oracle.misc

listing funcs and procs - 04-01-2010 , 02:45 PM

Re: listing funcs and procs - 04-01-2010 , 03:19 PM

Re: listing funcs and procs - 04-01-2010 , 04:41 PM

Re: listing funcs and procs - 04-02-2010 , 08:57 AM