How to get variables of any package in oracle?

@cortez.connelly 

You can use the following query to get the list of variables in any package in Oracle:

1
2
3
4
5

SELECT object_name, name, type
FROM all_arguments
WHERE owner = 'YOUR_SCHEMA_NAME'
AND package_name = 'YOUR_PACKAGE_NAME'
ORDER BY sequence;

Replace 'YOUR_SCHEMA_NAME' and 'YOUR_PACKAGE_NAME' with the appropriate values for your package. This query will return the object name, variable name, and type for each variable in the specified package.