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

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

Syntax

java.sql.Clob getXSPInoutClobForNull(int  index)
                            throws Exception

Argument

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.Clob object that represents the INOUT parameter of a Java external stored procedure when a Null object is passed in for the parameter. This object can be used to set the return value for the INOUT parameter that was passed in as a NULL.

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.