Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save nexocentric/22197a61cd55613aec8c to your computer and use it in GitHub Desktop.
Save nexocentric/22197a61cd55613aec8c to your computer and use it in GitHub Desktop.
--------------------------------------------------------
-- get a list of arguments for specifed stored procedure
--------------------------------------------------------
SELECT
argument_name,
in_out,
data_type
FROM
all_arguments
WHERE
owner = 'SYS' --the owner of the procedure
AND package_name = 'DBMS_OUTPUT' --the name of the package / null if not part of package
AND object_name = 'GET_LINE' --the name of the procedure
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment