SDO_NFE.CREATE_MODEL_WORKSPACE

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;
/