sippsin

 Profile Answers by sippsin 

• Feb 16th, 2007

 

select procedure_name from all_procedures

sampra

 Profile Answers by sampra 

• Mar 10th, 2008

 

select procedure_name from all_procedures

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 26th, 2008

 

I think all_procedures shows you the list of procedures you have access to but not that are used in database.

raheemrao

 Profile Answers by raheemrao 

• Jun 1st, 2008

 

select proc_name from user_procedures;

aparna_mhatre84

 Profile Answers by aparna_mhatre84 

• Jul 12th, 2008

 

select object_name from user_objects where object_type = 'PROCEDURE'

himanshu D silva

 Profile Answers by himanshu D silva 

• Mar 12th, 2009

 

sp_helptext procname will tell you if the procedure is existed or not as it will show you the whole syntax of that procedure.

Shafik Ismail

 Profile Answers by Shafik Ismail 

• Feb 26th, 2010

 

I am not too sure if I understand our question properly. If you wanted to find all the stored procedures defined to the database with a CREATE PROCEDURE command (let's say DB2), then run a query from SYSIBM.SYSROUTINES. If you want the parameters associated with these stored procedures, then run a query from SYSIBM.SYSPARMS.

suneesece

 Profile Answers by suneesece 

• May 19th, 2010

 

select * from all_objects where object_type= 'PROCEDURE';