Jeffrey Kevin Pry
Reputation: 3296
Get Package Methods and Parameters from Oracle
I am looking for the query for Oracle to get all parameters for an Oracle package / procedure.
I know there is a view or table that provides this, but I can't seem to remember what it is.
NOTE: I am not looking for getting a list of packages from user_objects, rather the data type and parameter name for each procedure in a package.
Thanks,
Jeffrey Kevin Pry
Upvotes: 6
Views: 4544
Answers (1)
Related Questions
- How get list of functions inside a package in oracle
- list of all functions/procedures called by each function/procedure in an oracle package
- Retreive a list of private procedures/functions from a package body
- How can I get DDL for a given Oracle package's "public" procedures?
- Get the calling package/procedure in Oracle
- oracle view all procedures and function inside of package
- (Oracle) How to get list of procedure, function in package?
- Native method to pull out metadata about packages, procedures and functions?
- How can I read functions and procedures body/ddl while they are in a package?
- PL/SQL: Retrieve names of procedures and functions within a package