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:
You can open the Oracle Stored Procedure Editor in one of the following ways:
You can open the Oracle Function Editor in one of the following ways:
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.
Positions the editor on the previous object in the Navigation Grid.
Positions the editor on the next object in the Navigation Grid.
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.
Creates a new object that becomes the current object in the editor.
Deletes the selected object.
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.
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.
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.
Specifies the name of the object. You can change the object name in this field.
Lets you assign a database owner to the selected procedure or function.
Specifies whether the object type is model-level or table-level. Select the type from the drop-down list.
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.
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.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
Review or assign code (including macros) to a stored procedure or function.
Review the code assigned to a stored procedure or function.
Note: Code is read-only in this tab.
Create, edit, or delete synonyms that apply to the selected object.
Lets you enter any comments that you want to associate with the object.
Specify the order of DDL generation for the object.
View where the object is used within the model.
Lets you enter user-defined property values for the object.
View object history information and view or edit user notes.
Copyright © 2012 CA. All rights reserved. |
|