SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to get list of parameters or arguments for a stored procedure

507661Aug 16 2007 — edited Aug 16 2007

Hi,

Is there a way we can get the list of arguments or parameters for a stored procedure through Data Dictionary?

I mean the way oracle has Meta Data tables like user_tables/dba_tables, user_triggers/dba_triggers through which we can get information about tables, triggers etc, in the same way is there a way in oracle so that we can get information about a procedure like what kind of arguments need to be passed, are they IN or OUT parameters, and what is their Data Types?

I could find there is one View dba_procedures, but it does not give any information about the arguments a procedure takes.

Thanks,
Makrand

Thansk

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2007

Added on Aug 16 2007

4 comments

1,110 views