Request a stored procedure for parameter names and types

Question

Is there any easy way to query a stored procedure (Oracle - PL / SQL) for the parameters that it expects?

I know that I can query USER_SOURCE to get the whole procedure, but I would have to parse the whole procedure, and if the parameter is of the type [table].[column]%TYPE , I would have to query the table schema as well.

Either using only sql or through ODP.Net.

Answer 1

In the USER_ARGUMENTS view, you will find detailed information.

Answer 2

Another method is to call DBMS_DESCRIBE.DESCRIBE_PROCEDURE .