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.