Skip to content

Instantly share code, notes, and snippets.

@nexocentric

nexocentric/Oracle SQL: List Stored Procedure Parameters

Created September 29, 2014 12:54
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nexocentric/22197a61cd55613aec8c to your computer and use it in GitHub Desktop.
Save nexocentric/22197a61cd55613aec8c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Oracle SQL: List Stored Procedure Parameters
--------------------------------------------------------
-- 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