Package Function Nodes

This section covers the following topics:

How the Package Function Nodes Works

A Package Function node is a child of the Packages node. It represents a function in a PL/SQL package and can have one or more child Parameter nodes, which represent parameters within that function. It also has a child Return Value node representing the return value for the function.

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

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

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

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

To perform actions on the Package Function node: right-click this 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 function using the Run dialog box.
Run Debug	Starts debugging the package function and runs to the breakpoint. See Debugging a PL/SQL Program Directly.
Step Into	Begins debugging the package function and stops at the line of code. See Debugging a PL/SQL Program Directly.
Copy	Copies the selected package function to the clipboard for pasting to Visual Studio designers. This provides the same functionality as dragging and dropping the package function to the Visual Studio designers.
Refresh	Updates the package function node tree, including its associated child nodes.
Properties	Displays the Properties window.