I have following java UDF which i'm calling from external stored procedure. Issue is when an SQLException occurs i get truncated error message in Parent SP Exit handler MESSAGE_TEXT of GET DIAGNOSTIC EXCEPTION 1 clasue
"SQLSTATE 38U01: [Teradata Database] [TeraJDBC 14.00.00.09] [Error 3707] [S"
Whereas at trace write the error message is completely logged.
Code is below.
REPLACE PROCEDURE ExternalSP