Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help. OCIDefineByPos leads to ORA-1007?

DanielSteinJun 6 2019 — edited Jun 13 2019

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.

This post has been answered by DanielStein on Jun 13 2019
Jump to Answer

Comments

AMSI
done.resovlesd my self
AMSI
done
1 - 2

Post Details

Added on Jun 6 2019
1 comment
705 views