@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.