Return list of Products containing input objects.
Input
Parameter | Type | Description |
|---|---|---|
foids | SYS_REFCURSOR | Array holding FOIDs to be queried. |
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
select * from TABLE(p_gpeapi.QUERY_GPE_OBJECTS( CURSOR( select identifier from productobject)))); |
Exceptions
None defined at this time.