Query a stored procedure for it's parameter names and types
- by ho1
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.