Add a workspace definition.
Input
Parameter | Type | Description |
|---|---|---|
v_description | VARCHAR2 | The description for the new workspace. This is limited to 1000 characters. |
v_name | VARCHAR2 | Name for the new workspace. This is limited to 100 characters. |
v_min_x | NUMBER | Longitude coordinate for lower-left corner of workspace. |
v_min_y | NUMBER | Latitude coordinate for lower-left corner of workspace. |
v_max_x | NUMBER | Longitude coordinate for upper-right corner of workspace. |
v_max_y | NUMBER | Latitude coordinate for upper-right corner of workspace. |
v_usage_id | NUMBER | Primary key for usage scale band. |
Example
DECLARE v_description CONSTANT VARCHAR2(1000) := 'Test Workspace API C'; v_name CONSTANT VARCHAR2(100) := 'Test C'; v_min_lat CONSTANT NUMBER := 43.071119920; --North v_min_long CONSTANT NUMBER := -70.724611637; --West v_max_lat CONSTANT NUMBER := 43.074168350; --North v_max_long CONSTANT NUMBER := -70.719432143; --West v_usage_id CONSTANT NUMBER := 1; BEGIN p_workspace_mgmt.addworkspace( v_description, v_name, v_min_long, v_min_lat, v_max_long, v_max_lat, v_usage_id); END; / |
Exceptions
• X values are identical.
• Y values are identical.
• Workspace name v_NAME is already used