Undocumented OCI Handle Attributes

This entry has been obsolete since Oracle 12.2. The following attributes are documented in Oracle 12.2 OCI manual.

---

OCI_ATTR_RECEIVE_TIMEOUT and OCI_ATTR_SEND_TIMEOUT are defined in oci.h but not documented in Oracle 12.1 OCI manual. I guess their specifications as follows.

---

Server Handle Attributes

OCI_ATTR_RECEIVE_TIMEOUT

   Mode
   READ/WRITE

   Description
   Specify the receive timeout in milliseconds.
   Specifying zero means no timeout.

   Attribute Data Type
   ub4 */ub4

OCI_ATTR_SEND_TIMEOUT

   Mode
   READ/WRITE

   Description
   Specify the send timeout in milliseconds.
   Specifying zero means no timeout.

   Attribute Data Type
   ub4 */ub4

---

I checked OCI_ATTR_RECEIVE_TIMEOUT on Linux with various Oracle versions.

Oracle 10.2 and earlier

"ORA-24315: illegal attribute type" on setting the attribute

Oracle 11.1

"ORA-03113: end-of-file on communication channel" on timeout

Oracle 11.2 and later

"ORA-12609: TNS: Receive timeout occurred" on timeout