Re: Location of parameters for procedures and functions

Nigel C. Myers wrote:

> Does anyone know which system views or tables store the parameters to
> procedures and functions ?

 I think what you are looking for is the all_arguments view (argument$ table) which argument details for both packages and stand alone procedures + functions (PACKAGE_NAME is null for these)

Alternatively you can use desc e.g.

desc package.procedure or

desc procedure

Hope this helps,

Ian Received on Mon Nov 10 1997 - 00:00:00 CST