Return the list of overlapping GPE products for a FOID.
Input
Parameter | Type | Description |
|---|---|---|
v_foid | NUMBER | The feature object identifier (FOID) as a number. See FOID Conversion Functions. |
v_usage_id | NUMBER | The usage to compare the GPE boundaries. |
Output
Type | Description |
|---|---|
enc_info | List of products containing foids queried. |
Definition of ENC_INFO
Name | Type | Description |
|---|---|---|
name | VARCHAR2 | Name of product. |
edition | NUMBER | Edition number. |
version | NUMBER | Version number. |
product_id | NUMBER | Base ID of the product. |
productversion_id | NUMBER | Version identifier. |
s57_type | NUMBER | Product Spec identifier relating to a type from table ENCTYPE. |
Example
The following example shows the use of this function on a PL/SQL block.
SELECT * FROM TABLE (p_gpeapi.GETPRODUCTSFROMFEATUREAREA (1,1)); |
Exceptions
None defined at this time.