Displaying Oracle database procedure details

In the DB Structure view, click any of the PROCEDURE child nodes to display details in the DB Details view about each procedure that is stored in the database and available for reuse. Procedure details include parameters; the source code; properties and their current values; and a list of any dependent objects.