Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Stored Procedure and Function Editor

Oracle Stored Procedure and Function Editor

The following describes both the Oracle Stored Procedure Editor and the Oracle Function Editor.

Use the Oracle Stored Procedure 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 Function Editor to add, change, view, or delete functions.

Stored procedures and functions are supported in the following features:

• Forward Engineering
• Reverse Engineering

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

• Select Stored Procedures on the Model menu
• Right-click a stored procedure in the Model Explorer and select Properties
• Right-click a table or view on the diagram and click Stored Procedure Properties

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

• Select Functions on the Model menu.
• Right-click a function in the Model Explorer and select Properties
• Right-click a table or view on the diagram and select Function Properties

Use the following options and tabs in the Oracle Stored Procedure Editor and Oracle Function Editor to add or modify properties for stored procedures and functions. Options that vary between stored procedures or functions are noted.

Previous

Positions the editor on the previous object in the Navigation Grid.

Next

Positions the editor on the next object in the Navigation Grid.

Sort

Sorts the objects by alphabetic or reverse alphabetic order. You select the method you want using the drop-down menu that opens after you click the Sort button. Visual cues are provided for how the object list is currently sorted:

Specifies that the object list is sorted in alphabetic order.

Specifies that the object list is sorted in reverse alphabetic order.

New

Creates a new object that becomes the current object in the editor.

Delete

Deletes the selected object.

Browser

Opens the Oracle Stored Procedure Browser or Function Browser so you can manage the tables and views that generate a table-level stored procedure or function.

Note: The Browser button is only enabled for table-level stored procedures or functions.

DB Sync

Opens the DB Sync wizard so you can perform a database level compare of objects in the current model with matching objects in another model.

Help

Opens online help for the editor.

Lets you filter a very large list of objects in the Navigation Grid to quickly locate the object for which you need to view or define properties.

Name

Specifies the name of the object. You can change the object name in this field.

DB Owner

Lets you assign a database owner to the selected procedure or function.

Type

Specifies whether the object type is model-level or table-level. Select the type from the drop-down list.

Attach To New

Specifies to attach the selected object to each new table that you create. Clear the check box if you want to manually attach a stored procedure or function to new tables.

Use Replace Syntax

Specifies that the selected stored procedure or function DDL that is generated during Forward Engineering 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.

Generate

Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

Code Tab

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

Expanded Tab

Review the code assigned to a stored procedure or function.

Note: Code is read-only in this tab.

Synonym Tab

Create, edit, or delete synonyms that apply to the selected object.

Comment Tab

Lets you enter any comments that you want to associate with the object.

Object Creation Order Tab

Specify the order of DDL generation for the object.

Where Used Tab

View where the object is used within the model.

UDP Tab

Lets you enter user-defined property values for the object.

Notes Tab

View object history information and view or edit user notes.