Created
September 29, 2014 12:54
-
-
Save nexocentric/22197a61cd55613aec8c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------- | |
-- 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