Re: How get stored procedure parameter list and their type?

You can interrogate the table user_source (or all_source) for the procedure text body.
For arguments, you can issue a DESC <procedure> from SQL Plus or look at the table user_arguments.

HTH, Mark

Li <l_zhou_at_hotmail.com> wrote in message news:<F8AA2253EC9D26E2.C298B189C72A61E1.87D0695101E362DA_at_lp.airnews.net>...
> Hi,
> Someone can tell me how to retrieve the text body from a procedure and
> get the list of parameters and parameter type. Of course I can process
> the string of the procedure, but is there a better way by using any
> command. Thanks a lot
Received on Wed Nov 14 2001 - 02:28:43 CST