Get package methods and parameters from Oracle

Question

I am looking for a query for Oracle to get all the parameters for an Oracle package / procedure.

I know there is a view or table that provides this, but I cannot remember what it is.

NOTE. I'm not looking to get a list of packages from user_objects, not the data type and parameter name for each procedure in the package.

Thanks,

Jeffrey Kevin Pry

Answer 1

You need USER_ARGUMENTS (or ALL_ARGUMENTS ) to view it.