Get a parameter's name

plsql, reflection

Solution

Try:

select argument_name from all_arguments where object_name = 'SP_EXAMPLE';

This view can also show you the data types, positions, etc., and you can use it in SQL or PL/SQL. Plenty of info in the various metadata views.

Problem

I want to get a parameter's name in plsql. For example, ``` procedure sp_example(myParam in varchar2) is paramName varchar2(30); begin paramName = 'myParam'; end end procedure sp_example; ``` Is there a way to get the name of `myParam` using reflection, instead of hard coding it?

Original source