[ https://issues.jboss.org/browse/TEIIDDES-2751?page=com.atlassian.jira.plu... ] Van Halbert edited comment on TEIIDDES-2751 at 1/13/16 4:02 PM: ---------------------------------------------------------------- First call to get the list of package objects: {code} select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); {code} Then call the following to get the arguments for a specific package object (procedure/function): {code} select * from user_arguments where package_name = '{package _name}' and object_name = '{object_name}' {code} was (Author: van.halbert): First call to get the list of package objects: select distinct ua.object_name, ua.package_name from user_arguments ua where ua.package_name in (select object_name from user_objects where object_type in ('PACKAGE') ); Then call the following to get the arguments for a specific package object (procedure/function): select * from user_arguments where package_name = \'{package _name}\' and object_name = \'{object_name}\' -- This message was sent by Atlassian JIRA (v6.4.11#64026)