SPJ w result set failed with ERROR[8940]

[Chong Hsu]

Tested with Trafodion build, 20140801-0830.

Calling a SPJ with result set:

   public static void RS263(String[] paramArrayOfString, ResultSet[] paramArrayOfResultSet)
     throws Exception
   {
     String str1 = "jdbc:default:connection";

     Connection localConnection = DriverManager.getConnection(str1);

     Statement localStatement = localConnection.createStatement(1003, 1007);

     String str2 = "select st1 from trs";

     paramArrayOfResultSet[0] = localStatement.executeQuery(str2);
     paramArrayOfResultSet[0].next();
     paramArrayOfString[0] = paramArrayOfResultSet[0].getString(1);
   }

it failed with ERROR[8940]:

*** ERROR[8940] User-defined function returned invalid data for output value 1. Details: VARCHAR length should not exceed 117. [2014-08-04 22:57:48]

Note: There are other QA test cases failed with same error, all have data with NULL value.

The SPJ Jar file is attached. Here are the steps to produce the error:

set schema testspj;

create library spjrs file '/<Jar location>/Testrs.jar';

create procedure RS263(out out_param varchar(150))
       language java
       parameter style java
       external name 'Testrs.RS263'
       dynamic result sets 1
       library spjrs;

CREATE TABLE TRS
  (
    ST1 VARCHAR(117) CHARACTER SET ISO88591
      COLLATE DEFAULT DEFAULT _ISO88591'B8YNT80Y'
  , ST2 CHAR(105) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT _ISO88591'EA6L0UJH'
  , ST3 CHAR(106) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT _ISO88591'DNIF7GJH'
  , ST4 CHAR(120) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT _ISO88591'J17RQ4WH'
  , ST5 CHAR(113) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT _ISO88591'J8N9E0A2'
  , ST6 CHAR(102) CHARACTER SET ISO88591 COLLATE
      DEFAULT DEFAULT _ISO88591'4MGI4DH1'
  , S0 NUMERIC(9, 2) DEFAULT 22
  , S1 DECIMAL(9, 2) DEFAULT 9 NOT NULL NOT
      DROPPABLE
  )
;

INSERT INTO TrS (s1, St1, St2, St3, St4, St5, St6, s0) VALUES (
          708.13,
                                                       '-275427.08804271324 192 -817608.8332214953 ',
      'WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW4M6L0UJH KM6L0UJH 1M6L0UJH 8M6L0UJH WM6L0UJH 2M6L0UJH NM6L0UJH ',
      ' CMIF7GJH 2MIF7GJH several HMIF7GJH 699141.592691117 923846.5980633064 Emma flew ',
      '225 quite a few 437RQ close to sprinted F37RQ 637RQ beneath K37RQ 598498.3059382555 cats lots of P37RQ4WH ',
      ' 8QN9E 6QN9E GQN9E0A2 EQN9E UQN9E Mike OQN9E0A2 Louise many -985737.648297855 Susan ',
                                                       null,
         78812.7) ;

INSERT INTO TrS (St2, St6, St4, St1, St3, s0, St5, s1) VALUES (

      'D66L0UJH 476L0UJH K76L0UJH 176L0UJH 876L0UJH W76L0UJH 276L0UJH N76L0UJH WWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWWW',
      ' Frank ran excitedly. Michael crawled gracefully! Ben hightailed across quite a few turtles??? ',
      '6666666666666666666666ZT7RQ beneath UT7RQ RT7RQ 610827.488916235 quickly -636872.9262176658 mice 3T7RQ WT7RQ ET7RQ4WH ',
                                                       null,
      ' close to lots of string C4IF7 Seals and pigs and snails? Oh My! ',
        78814.04,
      '3HN9E0A2 across carelessly 2HN9E0A2 BHN9E SHN9E0A2 MHN9E goats ZHN9E0A2 split PHN9E CHN9E ',
         2128.55) ;

Call RS263(?);

OUT_PARAM
--------------------------------------------------------------------------------------------------------------------------------
-275427.08804271324 192 -817608.8332214953

*** ERROR[8940] User-defined function returned invalid data for output value 1. Details: VARCHAR length should not exceed 117. [2014-08-04 22:57:48]