3.5.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 typeVARCHAR2
ID_ARRAY
, a nested table of the data typeNUMBER
DB_VERSION_OBJ
, an object that bundles version information of the installed 3D City Database instanceDB_VERSION_TABLE
, a nested table ofDB_VERSION_OBJ
DB_INFO_OBJ
, an object that bundles metadata of the used reference systemDB_INFO_TABLE
, a nested table ofDB_INFO_OBJ
The definition of the data types can be found in the SQL file for the
CITYDB_UTIL
package.