getArray(Map) - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
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. Any custom mapping provided will be ignored.
  • 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(Map<String,Class<?>>  map)
                throws SQLException

Syntax Elements

map
A java.util.Map object that contains mappings of SQL type names to classes in the Java programming language.

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.