CODEWITHSUNDEEP
oracle-databasestored-proceduresarguments
You Qi
You Qi

Reputation: 9211

Oracle Stored Procedure's Input Arguments

I know I can use the SQL below to query a list of stored procedures in Oracle:

SELECT * FROM USER_PROCEDURES
ORDER BY OBJECT_NAME

But how can I retrieve a list of arguments I needed to pass in for a particular stored proc?

Upvotes: 1

Views: 637

Answers (2)

ninesided
ninesided

Reputation: 23263

The system view all_arguments will give you this information, but bear in mind that it will yield no rows if the procedure in question has no parameters:

SELECT argument_name, data_type, in_out, position
FROM all_arguments
WHERE object_name = 'MY_PROC'
AND owner = USER
AND data_level = 0
ORDER BY position;

Upvotes: 4

Dennis
Dennis

Reputation: 4017

I found the following Oracle documentation to be helpful. I believe the command you are looking for is, 

  DESCRIBE procedure

Upvotes: 0

Related Questions