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

Posted by ho1 on Stack Overflow See other posts from Stack Overflow or by ho1
Published on 2010-06-17T14:36:14Z Indexed on 2010/06/18 1:23 UTC
Read the original article Hit count: 251

Filed under:
|
|
|
|

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.

© Stack Overflow or respective owner

Related posts about .NET

Related posts about sql