How to get variables of any package in oracle?

by cortez.connelly , in category: MySQL , 8 days ago

How to get variables of any package in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by jerad , 8 days ago

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