INOUT Parameter Binding is not working properly

[ibm]

INOUT Parameter Binding is not working properly

[abmusse]

Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).

---

v1.0.9 fixed it

[abmusse]

Original comment by Kristopher Baehr (Bitbucket: krisbaehr, GitHub: krisbaehr).

---

@dmabupt , I'm testing with 1.0.9 this morning and can confirm that the in/out parameter issue seems to be fixed. I've debugged the stored procedure to verify the values are going in, and coming out as expected, even after multiple calls. Thanks!

[abmusse]

Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).

---

Hello @krisbaehr ,
Would you verify if the issue is solved in idb-connector version 1.0.7?

[abmusse]

Original comment by Kristopher Baehr (Bitbucket: krisbaehr, GitHub: krisbaehr).

---

Thanks, @dmabupt

[abmusse]

Original comment by Xu Meng (Bitbucket: mengxumx, GitHub: dmabupt).

---

@krisbaehr Commit f844836 fixes the 'in/out parameter missing' issue. It is still being tested. If you wish to test it early, you can compile it with gcc.

[abmusse]

Original comment by Jesse G (Bitbucket: ThePrez, GitHub: ThePrez).

---

@xumeng, are we missing logic in the following block of code in db2stmt.cc?

#!c

      String::Utf8Value param(object->Get(0));
      if(inOutType == SQL_PARAM_INPUT && obj->spInCount < SP_PARAM_MAX) {  //It is an input parameter.
        buf = obj->spIn[obj->spInCount] = strdup(*param); //Get the parameter string value.
        obj->spInCount++;
        if(bindIndicator == 0) //CLOB
          obj->indicator[i] = paramLen = strlen(*param);
        else  if(bindIndicator == 1) {//NTS
          paramLen = 0;
          obj->indicator[i] = SQL_NTS;
        }
      }
      else if(inOutType == SQL_PARAM_OUTPUT && obj->spOutCount < SP_PARAM_MAX) {  //It is an output parameter.
        buf = obj->spOut[obj->spOutCount] = (char*)calloc(paramSize + 1, sizeof(char));
        obj->spOutCount++;
        obj->indicator[i] = paramLen = paramSize;
      }
      DEBUG("SQLBindParameter [%d] = %s \n", i + 1, buf)
      rc = SQLBindParameter(obj->stmth, i + 1, inOutType, SQL_C_CHAR, dataType, paramSize, decDigits, buf, paramLen, &obj->indicator[i]);