Hi folks,
I was wondering whether there is any dictioanry view to see the parameters and datatype for a procedure/package.
I know DESC PROCEDURE will list all the parameters but from which table or view does it get the info.
TIA.
Sanjay
Printable View
Hi folks,
I was wondering whether there is any dictioanry view to see the parameters and datatype for a procedure/package.
I know DESC PROCEDURE will list all the parameters but from which table or view does it get the info.
TIA.
Sanjay
dba_arguments
Thanks Pando, that is exactly what I was looking for.
:) Sanjay