17.10 - getArrayNumDimension() - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Retrieves the number of dimensions for an Array/Varray type. This method is not applicable to any other UDT or complex types.

The method returns a constant of type int that contains the number of dimensions of this Array/Varray type.

The method throws SQLException if an error occurs while attempting to access the dimensions information. A database specific code “9744 (ERRUDFJAVUDT) < Number of dimensions for Array/Varray could not be accessed>” is returned.


int getArrayNumDimension()
                       throws SQLException