Return a list of products containing input objects.
Input
Parameter | Type | Description |
|---|---|---|
v_foids | FOID_TAB | Array holding FOIDs to be queried. |
isaml | NUMBER | 0 to return AML products, 1 to return ENC Products. |
Definition of FOID_TAB
Name | Type | Description |
|---|---|---|
foid | NUMBER | The feature object identifier (FOID) as a number. See FOID Conversion Functions. |
Output
Parameter | Type | Description |
|---|---|---|
enc_info | Pipelined array | 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
select * from table(p_encapi.enc_objects(p_project_manager.getProjectFeatures(3),1)); |
Exceptions
None defined at this time.