Return list of products containing input objects.
Output is from the ENC_INFO table of ENC_INFO_REC.
Products are represented by a numeric value from the ENCTYPE table. Product types and corresponding values are shown below
S57_Type | Value |
|---|---|
ENC | 3 |
CLB | 6 |
ESB | 7 |
LBO | 8 |
MFF | 9 |
RAL | 10 |
SBO | 11 |
GML | 15 |
Input
Parameter | Type | Description |
|---|---|---|
foids | sys_refcursor | Array holding FOIDs to be queried. |
Output
Parameter | Type | Description |
|---|---|---|
enc_info | Pipelined array | List of products containing FOIDs queried. enc_info is table of enc_info_rec. See below. |
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 (for details, see the Purpose section). |
Example
select * from TABLE(p_encapi.QUERY_ENCS_OBJECTS( (CURSOR( select identifier from productobject)))); |
Exceptions
None defined at this time.