Package Procedure Nodes

This section covers the following topics:

How the Package Procedure Nodes Works

A Package Procedure node is a child of the Package node. It represents a procedure in PL/SQL package and can have one or more child Parameter nodes, which represent parameters within that procedure.

Double-clicking on a package procedure node opens the PL/SQL editor with the package specification and takes you to the line of code that contains the procedure definition.

A package procedure with an error is indicated by a red x in the package procedure icon.

To fix the error, open the package procedure in the PL/SQL editor, make the required changes, and save the changes to the database. If the package procedure and the package have no errors, the x is removed from the package node and all the child nodes of the package node.

Procedures that have been compiled with debug information have DBG embedded in the icon.

To perform actions on the Package Procedure node: right-click the node and from the menu, choose the appropriate command. To view the node's properties, select the node and/or click Properties in the node's menu.

Menu Options

Menu Option Description

Edit Specification

Opens the package specification in the PL/SQL Code Editor.

If the window for the package specification already exists, Edit Specification makes it the current window.

Run

Executes the package procedure using the Run dialog box.

Run Debug

Starts debugging the package procedure and runs to the breakpoint. See Debugging a PL/SQL Program Directly.

Step Into

Begins debugging the package procedure and stops at the line of code. See Debugging a PL/SQL Program Directly.

Copy

Copies the selected package procedure to the clipboard for pasting to Visual Studio designers. This provides the same functionality as dragging and dropping the package procedure to the Visual Studio designers.

Refresh

Updates the package procedure node tree, including its associated child nodes.

Properties

Displays the Properties window.