Create a view containing features of the specified object class within the input rectangle and usage specified. The columns of the view are the valid attributes and also include foid, foid_string, featver_id, spatver_id, and rep_id.
Input
Parameter | Type | Description |
|---|---|---|
v_name | VARCHAR2 | The name of the view to create. If a view with this name already exists, it is replaced with the new view. |
v_acronym | VARCHAR2 | The acronym of the feature object class included in the view. |
v_usage | VARCHAR2 | The name of the usages from which the view will query features. This is case- insensitive. |
v_profilename | VARCHAR2 | The profile to use to define which attributes the object class has. This is case-insensitive. |
v_spatial_type | VARCHAR2 | The spatial type of the objects to include in the view. • S = sounding • P = point • A = area • T = text • L = line • NULL = any type of object' |
v_maxlon | NUMBER | The desired maximum longitude. May be NULL to include objects from all locations in the world. These parameters must be NULL unless v_spatial_type is specified. These 4 parameters must all be NULL or NOT NULL. |
v_maxlat | NUMBER | The desired maximum latitude. May be NULL to include objects from all locations in the world. These parameters must be NULL unless v_spatial_type is specified. These 4 parameters must all be NULL or NOT NULL. |
v_minlon | NUMBER | The desired minimum longitude. May be NULL to include objects from all locations in the world. These parameters must be NULL unless v_spatial_type is specified. These 4 parameters must all be NULL or NOT NULL. |
v_minlat | NUMBER | The desired minimum latitude. May be NULL to include objects from all locations in the world. These parameters must be NULL unless v_spatial_type is specified. These 4 parameters must all be NULL or NOT NULL. |
Output
May be NULL to include objects from all locations in the world. These parameters must be NULL unless v_spatial_type is specified. These 4 parameters must all be NULL or NOT NULL. |
An example view for a BOYLAT object class is shown below.
Column | Type | Description |
|---|---|---|
foid | VARCHAR2 | Feature object identifier (FOID) as a number. See FOID Conversion Functions. |
foid_string | VARCHAR2 | Feature object identifier (FOID) as a string. Although this is convenient for display, it is more efficient to query by the foid as a number. See FOID Conversion Functions |
featver_id | NUMBER | Primary key of the feature version. |
spatver_id | NUMBER | Primary key of the spatial version. |
rep_id | NUMBER | Primary key of the spatial representation. |
boyshp | VARCHAR2 | Attribute of input object as defined in input profile. |
catlam | VARCHAR2 | Attribute of input object as defined in input profile. |
colour | VARCHAR2 | Attribute of input object as defined in input profile. |
colpat | VARCHAR2 | Attribute of input object as defined in input profile. |
conrad | VARCHAR2 | Attribute of input object as defined in input profile. |
datend | VARCHAR2 | Attribute of input object as defined in input profile. |
datsta | VARCHAR2 | Attribute of input object as defined in input profile. |
inform | VARCHAR2 | Attribute of input object as defined in input profile. |
marsys | VARCHAR2 | Attribute of input object as defined in input profile. |
natcon | VARCHAR2 | Attribute of input object as defined in input profile. |
ninfom | VARCHAR2 | Attribute of input object as defined in input profile. |
nobjnm | VARCHAR2 | Attribute of input object as defined in input profile. |
ntxtds | VARCHAR2 | Attribute of input object as defined in input profile. |
objnam | VARCHAR2 | Attribute of input object as defined in input profile. |
perend | VARCHAR2 | Attribute of input object as defined in input profile. |
persta | VARCHAR2 | Attribute of input object as defined in input profile. |
picrep | VARCHAR2 | Attribute of input object as defined in input profile. |
recdat | VARCHAR2 | Attribute of input object as defined in input profile. |
recind | VARCHAR2 | Attribute of input object as defined in input profile. |
scamax | VARCHAR2 | Attribute of input object as defined in input profile. |
scamin | VARCHAR2 | Attribute of input object as defined in input profile. |
sordat | VARCHAR2 | Attribute of input object as defined in input profile. |
sorind | VARCHAR2 | Attribute of input object as defined in input profile. |
status | VARCHAR2 | Attribute of input object as defined in input profile. |
txtdsc | VARCHAR2 | Attribute of input object as defined in input profile. |
veracc | VARCHAR2 | Attribute of input object as defined in input profile. |
verlen | VARCHAR2 | Attribute of input object as defined in input profile. |
Example
The following example shows the use of this function on a PL/SQL block and an ad hoc query.
BEGIN p_hpdview.createobjectview('BOYLAT_LST', 'BOYLAT', 'Harbour(4000-21999)', 'S-57 Source', 'P', -70.6018, 41.777, -70.7749, 41.633); END; / select * from boylat_lst; |
Exceptions
• View name can not be NULL.
• Object acronym 'v_acronym' is not valid.
• Input Profile name 'v_profilename' is not valid.
• Input usage 'v_usage' is not valid.
• Input spatial type 'v_spatial_type' is not valid.
• Either all min/max lat/long values must be NULL or all must be NOT NULL.
• Spatial type must be specified when limiting the results by geometry.
• ORA-01467: sort key too long - this means that there are too many attributes for this object class. Approximately 20 attributes are supported..