SDO_NFE.CREATE_MODEL

Format

SDO_NFE.CREATE_MODEL_WORKSPACE(
     model_id              IN NUMBER,
     parent_workspace_name IN VARCHAR2,
     workspace_name        IN VARCHAR2,
     is_mbr    IN VARCHAR2,
     is_locked IN VARCHAR2,
     lower_x   IN NUMBER,
     lower_y   IN NUMBER,
     upper_x   IN NUMBER,
     upper_y   IN NUMBER);

Description

Creates a new workspace and relates it to an NFE model.

Parameters

model_id: ID of the NFE model.
parent_workspace_name: Name of the parent workspace.
workspace_name: Name of the workspace.
is_mbr: The string TRUE if the workspace is created for a minimum bounding rectangle (MBR) rectangular area of the model.
is_locked: The string TRUE if the workspace is locked.
lower_x: The lower x ordinate of the workspace MBR.
lower_y: The lower y ordinate of the workspace MBR.
upper_x: The upper x ordinate of the workspace MBR.
upper_y: The upper y ordinate of the workspace MBR.

Usage Notes

The NFE model must have been created with the versionable option enabled.

Examples

The following example creates a workspace for an NFE model.

DECLARE
  model_id        NUMBER := 1;
  parent_ws_name  VARCHAR2(30) := 'LIVE';
  workspace_name  VARCHAR2(30) := 'PROJECT_V1';
  is_mbr          VARCHAR2(1) := 'Y';
  is_locked       VARCHAR2(1) := 'N';
  lower_x NUMBER := -15.575;
  lower_y       NUMBER :=  15.575;
  upper_x NUMBER := -12.825;
  upper_y NUMBER :=  28.975;
BEGIN
  SDO_NFE.create_model_workspace(model_id, parent_ws_name, workspace_name, is_mbr, is_locked, lower_x, lower_y, upper_x, upper_y);
END;
/

7.6 SDO_NFE.CREATE_MODEL_WORKSPACE