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

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Purpose

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.

Syntax

Object getArray()
                throws SQLException

Return Value

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.

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.