2.10.1. User-defined data typesΒΆ
The Oracle version defines a set of user-defined data types that are used by functions from the PL/SQL packages. They are not necessary in PostgreSQL, because of how it deals with arrays and returns of multiple variables.
- STRARRAY, a nested table of the data type VARCHAR2
- ID_ARRAY, a nested table of the data type NUMBER
- DB_VERSION_OBJ, an object that bundles version information of the installed 3D City Database instance
- DB_VERSION_TABLE, a nested table of DB_VERSION_OBJ
- DB_INFO_OBJ, an object that bundles metadata of the used reference system
- DB_INFO_TABLE, a nested table of DB_INFO_OBJ
The definition of the data types can be found in the SQL file for the CITYDB_UTIL package.