GETSHEETVERSIONATTRIBUTES

Return properties of a sheet.

Input

Parameter	Type	Description
v_sheetver_id	INTEGER	Primary key of a sheet version.

Output

Type	Description
feature_attrib_tab Pipelined array	Attribute acronyms and values that are associated with this sheet version ID. 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 acronym.
att_value	CLOB	Attribute value.
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)

Name

Type

Description

acronym

VARCHAR2

Attribute acronym.

att_value

CLOB

Attribute value.

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_pprapi.getsheetversionattributes(:sheetver_id));

Exceptions

• Sheet version identifier '<sheetver_id>' is invalid or does not currently exist.