Menu
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
796
You can use user_source or all_source data dictionary view to view the procedure or function code.
Go to VIEW menu, click on find DB objects option. In the find db object pane put the name of the package and select the DB. Both, the spec and body will appear, double click to open.
You cannot execute a PL/SQL package, as it is simply a container for one or more routines (stored procedures and functions). Typically you use packages to organize various related routines. You execute (call) individual routines in a package by referencing them by their names, e.g.
A package is a group of related procedures and functions, together with the cursors and variables they use, stored together in the database for continued use as a unit. Similar to standalone procedures and functions, packaged procedures and functions can be called explicitly by applications or users.
The view you need is USER_ARGUMENTS (or ALL_ARGUMENTS).
61
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
