Return attribute information for a given ENC or AML product.
If the returned clob is greater than 4000 bytes then it must be handled with package DBMS_LOB.
Input
Parameter | Type | Description |
|---|---|---|
v_productversion_id | NUMBER | The primary key of the product version. |
Output
Parameter | Type | Description |
|---|---|---|
feature_attrib_tab | Pipelined array | Attribute acronyms and values that are associated with this FOID. Information is organized into a table with three rows: acronym (attribute acronym), att_value (attribute value), and type. |
Definition of FEATURE_ATTRIB_TAB
Name | Type | Description |
|---|---|---|
acronym | VARCHAR2 | Attribute class acronym. |
att_value | CLOB | Value of the attribute. |
type | VARCHAR2 | Type of attribute defined in ATTRIBUTE_TYPE. The following values are used: • S - string L - list • A - alphanumeric E- enumeration W - date • I - integer F- float • T - text (reference to a file) • R - raster (reference to a file) |
Example
select * from TABLE(p_encapi.getproductversionattributes(v_productversion_id)); |
Exceptions
None defined at this time.