MetaData for Oracle Store Procedure

I am working with several databases MySQL, SQL Server, Oracle) that possess their own store procedures. In SQL Server, I can use a system store procedure (sp_help) and obtain all the meta data concerning a specific store procedure, such as parameter names, type, length, order, etc. In MySQL, there is a table called proc with like information.

Here is my question: Does oracle have a system store procedure or table where I can gain meta data information involving a store procedure?

Thanks in advance for reading my post.

Russ

Have a look at the Oracle reference:

http://oraclesvca2.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_ddl.htm#1000985
and
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2109.htm#1299488
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch2124.htm#1300946

Okay I looked at the links.

What I see is the below store procedure:

ALL_PROCEDURES, ALL_SOURCE.

What I am missing is information concerning the parameters for the store procedures, such as type, order, and name.

Any hints?

Russ

Actually the first link should be:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_metad2.htm
sorry for the confusion.

This package will (re-)create the full SQL for a procedure (or table, or view, ...)

Concerning the the procedure parameters, I think this is stored in the view all_arguments.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch210.htm#1289073