This content has been marked as final. Show 3 replies
select * from ALL_ARGUMENTS;
Take a look at "Describing Schema Metadata" in the Programmer's Guide. It has this sort of information which may be enough to get you going in the right direction. The guide is here:
In particular, see the sample code in the "Describing the Stored Procedure" section.
Also here are few views which help on Stored procedures.