Creating Models › Creating a Physical Model › Materialized Views › Add a Stored Procedure for a Materialized View

Add a Stored Procedure for a Materialized View

To add a stored procedure for a materialized view

1. In a physical model based on Oracle, right-click a materialized view in the diagram and select Stored Procedures.

   The Procedures Editor opens.

2. Select New to open the Create Stored Procedure dialog.
3. Enter a name for the new stored procedure and click OK.
4. Select the General tab and select Table-Level.
5. Select the Code tab and enter the code for the new stored procedure. You can use macros in the stored procedure template.
6. (Optional) Perform the following:
   • Select the Comments tab and enter comments about the stored procedure.
   • Select the UDP tab to specify a user-defined property for the stored procedure.
7. Click OK.

Note: The order in which you add stored procedures to your model is important. The stored procedure code is generated according to the order in the Procedures Editor. You can change this order at any time in the Object Creation Order tab.