1 Reply Latest reply on Jun 13, 2019 6:01 AM by DanielStein

    Help. OCIDefineByPos leads to ORA-1007?

    DanielStein

      Hello,

       

      we've got an OCI-Application which raises an ORA-01007 using an 11.2.0.3 client.

       

      We did an OCI-Trace and got the following:

       

      # 06/06/19 11:22:02:851 # Thread ID 258 # Entry - OCIDefineByPos(stmhp = 33abb7cc, defnp = 3050416c, errhp = 3034c1e4, position = 42, valuep = 30c39403, value_sz = 8, dty = 96, indp = 30c61a1b, rlenp = 0, rcodep = 0, mode = 8(0x0000008));
      # 06/06/19 11:22:02:852 # Thread ID 258 # Exit - OCIDefineByPos
      
      # 06/06/19 11:22:02:852 # Thread ID 258 # Entry - OCIErrorGet(hndlp = 3034c1e4, recordno = 1, sqlstate = NULL, errcodep = 300a4500 = -1, bufsiz = 512, type = OCI_HTYPE_ERROR);
      # 06/06/19 11:22:02:852 # Thread ID 258 # Exit - OCIErrorGet
      # 06/06/19 11:22:02:852 # Thread ID 258 # Entry - OCIErrorGet(hndlp = 3034c1e4, recordno = 1, sqlstate = NULL, errcodep = 300a4440 = -1, bufsiz = 512, type = OCI_HTYPE_ERROR);
      # 06/06/19 11:22:02:852 # Thread ID 258 # Exit - OCIErrorGet
      # 06/06/19 11:22:02:852 # Thread ID 258 # Entry - OCIAttrGet(trgthndlp = 33abb7cc, trghndltyp = 4, attributep = 300a4550, sizep = 0, attrtype = OCI_ATTR_PARSE_ERROR_OFFSET, errhp = 3034c1e4);
      # 06/06/19 11:22:02:852 # Thread ID 258 # Exit - OCIAttrGet
      # 06/06/19 11:22:02:859 # Thread ID 258 # Entry - OCITransRollback(svchp = 3034c1e4, errhp = 0, flags = 0);
      # 06/06/19 11:22:02:861 # Thread ID 258 # Exit - OCITransRollback
      

       

      33abb7cc is the handle of our statement. It has 134 Columns in its Select-List. It seems that while defining the item at pos 42 (first line) two errors happend.

      The application does two OCIErrorGet with the handle 3034c1e4. This handle is the errorhandle (errhp) of our statement. But we are unable to translate the errcodeps (300a4500, 300a4440) into something meaningfull.

       

      Help is very much appreciated.