Procedures Node

This section covers the following topics:

About Procedures

A procedure is a named set of PL/SQL statements designed to perform an action. Unlike functions, procedures do not return values, but they can accept values as input.

How the Procedures Node Works

The Procedures node contains one or more child Procedure nodes. To perform actions on the Procedures 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.

If this collection node is filtered, the icon changes to include a funnel symbol. For more information about filtering, see Filtering Collection Nodes.

Menu Options

Menu Option Description

New PL/SQL Procedure

Creates a new PL/SQL procedure using the Procedure Designer.

New .NET Procedure

Deploys the procedure to an Oracle database as a .NET Assembly using the Oracle Deployment Wizard for .NET. Only enabled for connections with SYSDBA role.

Query Window

Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio.

Compile

Performs the following actions:

  1. If the procedure is open in the PL/SQL Editor and has been changed, saves the changes to the database.

  2. Compiles the procedure.

See PL/SQL Compiler Settings Options Page for compile settings.

Compile Debug

Compiles the procedure with debug information.

This is required before PL/SQL code can be debugged. See Compiling a PL/SQL Program with Debug Information.

See PL/SQL Compiler Settings Options Page for compile settings.

Generate Create Script

Writes the procedure definitions to a .sql file.

If the object associated with the procedures node is deleted from the database backend, this menu option does the following:

Displays a message indicating that this object no longer exists in Oracle Database, and the script will not be generated.

Generate Create Script to Project

Generates the procedure definitions to a .sql file and adds the .sql file to an open Oracle Database Project.

If multiple objects in Server Explorer are selected, a master SQL script is created in the Oracle Database Project Scripts folder. This master script contains calls to individual child SQL scripts (one for each schema object) generated into the various schema object folders and this master script is ordered with dependencies taken into consideration.

If there are multiple open Oracle Database projects, Visual Studio prompts you to select the project to add the script to.

This operation can also be performed by dragging and dropping the Server Explorer node(s) directly onto a database project folder.

See Managing Oracle Script Files for more information.

Note: Oracle Database Project Version 2 projects are not supported. To add scripts to this project type, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool.

Filters

Opens the Filters Tab to control which child nodes appear under the collection.

Privileges

Opens the Grant/Revoke Privileges dialog box.

Copy

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

Refresh

Updates the Procedures node tree, including its associated procedure and parameter nodes.

Properties

Displays the Properties window.