Physical Modeling › Oracle Physical Property Editors › Oracle Procedures and Functions Editor

Oracle Procedures and Functions Editor

The following describes both the Oracle Procedures Editor and the Oracle Functions Editor.

Use the Oracle Procedures Editor to add, change, view, or delete stored procedures for a model, tables, materialized views, or views. You can add stored procedures, which are a named set of precompiled SQL statements that are stored on the server and are invoked from the client by a remote procedure call. Support is provided for stored procedures for tables, materialized views, views, and at the model level.

Use the Oracle Functions Editor to add, change, view, or delete functions. It is only available for Oracle 9i and 10g. For Oracle 9i and 10g, functions are supported in the following features:

• Forward Engineering
• Reverse Engineering

You can open the Oracle Procedures Editor in one of the following ways:

• Select Stored Procedures from the Database menu, and select either Model-level or Table-level
• Right-click a stored procedure in the Model Explorer and select Properties
• Single-click a stored procedure in the Model Explorer and click the Property Editor icon

Open the Oracle Functions Editor by selecting Functions from the Database menu. You can select either Model-level or Table-level display.

Both the Oracle Procedures Editor and the Oracle Functions Editor dialog includes the following tabs:

Comment Add or edit comments for a stored procedure or function.

General Review or assign the type of stored procedure or function.

Code Review or assign code (including macros) to a stored procedure or function.

Expanded Review the code assigned to a stored procedure or function. Code is read-only in this tab.

Synonym Create, edit, or delete synonyms that apply to the selected stored procedure or function.

Object Creation Order Specify the order of creation for a stored procedure or function.

UDP Enter user-defined property values for the selected stored procedure or function.

The following describes the other options available in this dialog. Some options will be different based on whether you opened the Oracle Procedures Editor or the Oracle Functions Editor and are noted accordingly:

Display

A drop-down list where you can choose to list All procedures or functions, only Model-level procedures or functions, or only Table-level procedures or functions.

Procedures

A list box that contains all the available procedures based on what you selected for your Display if you opened the Oracle Procedures Editor.

Functions

A list box that contains all the available functions based on what you selected for your Display if you opened the Oracle Functions Editor.

Owner

You can enter a name in this text box to assign a database Owner to the selected procedure or function.

New

Select New to create a new procedure or function. If you are in the Oracle Procedures Editor, New opens the Create Stored Procedure dialog where you can specify the name for the new procedure. If you are in the Oracle Functions Editor, New opens the Create Function dialog where you can specify the name for the new function.

Rename

Select Rename to rename a procedure or function that you select from the Procedures or Functions list box, respectively. If you are in the Oracle Procedures Editor, it opens the Rename Stored Procedure <Stored Procedure Name> dialog where you can assign a different name to the procedure. If you are in the Functions Editor, it opens the Rename Function <Function Name> dialog.

Delete

Select a procedure from the Procedures list box that you want to delete, and click the Delete button. In the Oracle Functions Editor, select a function from the Functions list box that you want to delete.

Browser

Opens the Oracle Procedures Browser Editor where you can attach, review, and detach stored procedures to tables and views. If you are in the Oracle Functions Editor, Browser opens the Oracle Functions Browser where you can attach, review, and detach functions to tables and views.

Generate

Select this check box if you want to generate DDL for this object during Forward Engineering. If you do not select the check box, no DDL will be generated for this object during Forward Engineering.

Create or Replace

Select this check box if you want the stored procedure or function DDL that is generated during Forward Engineering to replace any occurrence of an identically-named stored procedure or function. If this check box is not selected, the stored procedure or function DDL generated will only attempt to create the object and will not attempt to replace it.

DB Sync

Starts the Complete Compare task so you can synchronize the physical objects defined in your model with the information stored on the server.