what is the syntax to get the stored procedure list from the database? i use oracle 8i thanks





Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com

Hi, is this what you're looking for ?



select * from all_objects where OBJECT_TYPE = 'PROCEDURE'



if not, please explain more .

Cheers,

Danny