Prev: Location Intelligence demo
Next: how to browse all sys_context(...) values?
From: seannakasone on 1 Apr 2010 15:45
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
From: Michel Cadot on 1 Apr 2010 16:19

"seannakasone" <snakason(a)flex.com> a �crit dans le message de news:
Pine.CYG.4.58.1004010942240.2888(a)CTFANXNFBA.unjnvvnaryrpgevp.arg...
| 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


From: seannakasone on 1 Apr 2010 17:41
that's what i needed. thankyou!!

From: Mark D Powell on 2 Apr 2010 09:57
On Apr 1, 3:45 pm, seannakasone <snaka...(a)flex.com> wrote:
> 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 --

 | 
Pages: 1
Prev: Location Intelligence demo
Next: how to browse all sys_context(...) values?