Returning SQLSTATE Values | Java External Stored Procedures | Teradata Vantage - 17.10 - Returning SQLSTATE Values - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

A Java external stored procedure can throw a java.lang.SQLException with an exception number and message that are returned to the database and used to set the SQLSTATE value and error message.

Valid values for the SQLState field of the SQLException are in the range 38U00 to 38U99.

Here is an example:

public class region {

   public static void newRegion( Integer[] regionID )
   throws SQLException
   {
       if (regionID[0] != null)
          regionID[0] = regionID[0].intValue() + 1;
       else
          throw new SQLException("Region ID not valid", "38U01");
   }

   ...

}

SQLException is the only valid exception that Java external stored procedures can throw.