CODEWITHSUNDEEP
.netsqloracle-databaseplsqlodp.net
Hans Olsson
Hans Olsson

Reputation: 55059

Query a stored procedure for it's parameter names and types

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

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

Either using just sql or via ODP.Net.

Upvotes: 1

Views: 475

Answers (2)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

Another method is to call DBMS_DESCRIBE.DESCRIBE_PROCEDURE.

Upvotes: 0

dpbradley
dpbradley

Reputation: 11935

The USER_ARGUMENTS view will give you the details.

Upvotes: 3

Related Questions