6.14. ODPI-C Enumeration dpiOracleTypeNum
This enumeration identifies the types of Oracle data that can be used for binding data as arguments to a statement, fetching data from the database, or getting and setting object attributes and element values.
Value |
Description |
|---|---|
DPI_ORACLE_TYPE_BFILE |
Default type used for BFILE columns in the database. Only a locator is transferred to/from Oracle, which can subsequently be used via dpiLob references to read/write from that locator. |
DPI_ORACLE_TYPE_BLOB |
Default type used for BLOB columns in the database. Only a locator is transferred to/from Oracle, which can subsequently be used via dpiLob references to read/write from that locator. |
DPI_ORACLE_TYPE_BOOLEAN |
Used within PL/SQL for boolean values. This is only available in 12.1. Earlier releases simply use the integer values 0 and 1 to represent a boolean value. Data is transferred to/from Oracle as an integer. |
DPI_ORACLE_TYPE_CHAR |
Default type used for CHAR columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for CHAR data. |
DPI_ORACLE_TYPE_CLOB |
Default type used for CLOB columns in the database. Only a locator is transferred to/from Oracle, which can subsequently be used via dpiLob references to read/write from that locator. |
DPI_ORACLE_TYPE_DATE |
Default type used for DATE columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_INTERVAL_DS |
Default type used for INTERVAL DAY TO SECOND columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_INTERVAL_YM |
Default type used for INTERVAL YEAR TO MONTH columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_JSON |
Default type used for JSON columns in the database (available in Oracle Database 20 and higher). Data is transferred to/from Oracle using the structure dpiJsonNode. |
DPI_ORACLE_TYPE_JSON_ARRAY |
Type used for identifying nodes that are JSON arrays. Data is transferred to/from Oracle using the structure dpiJsonArray. |
DPI_ORACLE_TYPE_JSON_ID |
Type used for identifying nodes that are JSON IDs. Data is transferred to/from Oracle as raw byte strings. |
DPI_ORACLE_TYPE_JSON_OBJECT |
Type used for identifying nodes that are JSON objects. Data is transferred to/from Oracle using the structure dpiJsonObject. |
DPI_ORACLE_TYPE_LONG_NVARCHAR |
This value cannot be represented in an Oracle database but is used when fetching NCLOB data as a string. Data is transferred to/from Oracle as byte strings in the encoding used for NCHAR data. |
DPI_ORACLE_TYPE_LONG_RAW |
Default type used for LONG RAW columns in the database. Data is transferred to/from Oracle as raw byte strings. |
DPI_ORACLE_TYPE_LONG_VARCHAR |
Default type used for LONG columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for CHAR data. |
DPI_ORACLE_TYPE_NATIVE_DOUBLE |
Default type used for BINARY_DOUBLE columns in the database. Data is transferred to/from Oracle as the C double type. |
DPI_ORACLE_TYPE_NATIVE_FLOAT |
Default type used for BINARY_FLOAT columns in the database. Data is transferred to/from Oracle as the C float type. |
DPI_ORACLE_TYPE_NATIVE_INT |
Type available for binding native integers directly in PL/SQL (such as PLS_INTEGER). Data is transferred to/from Oracle as 64-bit integers. |
DPI_ORACLE_TYPE_NATIVE_UINT |
Type available for binding native integers directly in PL/SQL (such as PLS_INTEGER). Data is transferred to/from Oracle as 64-bit unsigned integers. |
DPI_ORACLE_TYPE_NCHAR |
Default type used for NCHAR columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for NCHAR data. |
DPI_ORACLE_TYPE_NCLOB |
Default type used for NCLOB columns in the database. Only a locator is transferred to/from Oracle, which can subsequently be used via dpiLob references to read/write from that locator. |
DPI_ORACLE_TYPE_NUMBER |
Default type used for NUMBER columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_NVARCHAR |
Default type used for NVARCHAR2 columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for NCHAR data. |
DPI_ORACLE_TYPE_OBJECT |
Default type used for named type columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_RAW |
Default type used for RAW columns in the database. Data is transferred to/from Oracle as raw byte strings. |
DPI_ORACLE_TYPE_ROWID |
Default type used for the pseudocolumn “ROWID”. Data is transferred to/from Oracle as byte strings, in the encoding used for CHAR data. |
DPI_ORACLE_TYPE_STMT |
Used within PL/SQL for REF CURSOR or within SQL for querying a CURSOR. Only a handle is transferred to/from Oracle, which can subsequently be used via dpiStmt for querying. |
DPI_ORACLE_TYPE_TIMESTAMP |
Default type used for TIMESTAMP columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_TIMESTAMP_LTZ |
Default type used for TIMESTAMP WITH LOCAL TIME ZONE columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_TIMESTAMP_TZ |
Default type used for TIMESTAMP WITH TIME ZONE columns in the database. Data is transferred to/from Oracle in Oracle’s internal format. |
DPI_ORACLE_TYPE_UROWID |
This value is currently a synonym for DPI_ORACLE_TYPE_ROWID. It is intended to be the default type for UROWID columns in the database when it is possible to distinguish betweeen ROWID and UROWID. Data is transferred to/from Oracle as byte strings, in the encoding used for CHAR data. |
DPI_ORACLE_TYPE_VARCHAR |
Default type used for VARCHAR2 columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for CHAR data. |
DPI_ORACLE_TYPE_XMLTYPE |
Default type used for SYS.XMLTYPE columns in the database. Data is transferred to/from Oracle as byte strings in the encoding used for CHAR data. |