Return attribute information for a given GPE product.
If the returned CLOB is greater than 4000 bytes then it must be handled with package DBMS_LOB. An example of DBMS_LOB is shown in GETA TTRIBUTES.
Input
Parameter | Type | Description |
|---|---|---|
v_productversion_id | NUMBER | The primary key of the product version. |
Output
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_gpeapi.getproductversionattributes(1)); |
The second code example is located in GETATTRIBUTES. That example can be used, with minor modifications, to call this function.
Exceptions
None defined at this time.