16.20 - getXSPInoutStructForNull(int) - 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

Returns an empty Struct object representing the INOUT parameter of a Java external stored procedure when a Null object is passed in for the parameter.

Syntax

java.sql.Struct getXSPInoutStructForNull(int  param_index)
                            throws Exception

Parameters

param_index
The index of the particular INOUT parameter as it appears in the list of parameters for the Java external stored procedure, starting from 0.

Return Value

The java.sql.Struct object that represents the INOUT parameter of a Java external stored procedure when a Null object is passed in for the parameter.

Exceptions

Throws Exception if any error occurs during the process which could be either IOException or SQLException depending on the root cause of the error.