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

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
Retrieves the contents of the SQL ARRAY value designated by this Array object in the form of an array in the Java programming language.
  • Teradata only supports standard mapping.
  • Both 1-D and N-D arrays are supported for this method.

An array in the Java programming language that contains the ordered elements of the SQL ARRAY value designated by this Array object. For N-D arrays, the elements are returned in row-major order.

Syntax

Object getArray()
                throws SQLException

Exceptions

Throws SQLException if an error occurs while attempting to access the array. A database specific code “9743 (ERRUDFJAVARRAY)<Failed to retrieve elements of the array>” is returned.