In the Oracle DB Structure View, click any of the PROCEDURE child nodes to display details in the Oracle 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.