RE: Procedure/Function Arguments list

[Jason Chapman-2]

Found the view, it is DBA_ARGUMENTS.

 

________________________________

From: Jason Chapman
Sent: Thursday, July 17, 2008 3:03 PM
To: toad@...
Subject: Procedure/Function Arguments list

 

Does anyone know how the TOAD software obtains the list of parameters
defined for a procedure or function?  We are trying to identify all
stored program units that have a parameter defined as VARCHAR2 and OUT.
We could use the ALL_SOURCE system view in ORACLE but thought there may
be a cleaner way since TOAD provides a tab showing the same information.

 

Thanks,

 

Jason