We call the following to get all stored procedures in oracle:
select object_name from user_procedures
And for each stored procedure, we call the following to get all parameters:
select object_name, argument_name, data_type, default_value, in_out, data_length, data_precision, data_scale, char_length from user_arguments order by POSITION
Which works great if the stored procedures are no in packages. But if they are in packages, then the first select will return the package name, not the stored procedure name, for each stored procedure.
For the case where the stored procedures are inside packages, what select can we call to get all of them? Preferably a call that returns all names for both inside packages and stand-alone.