34 #ifndef OCILIB_H_INCLUDED 35 #define OCILIB_H_INCLUDED 74 #if defined(_WIN32)|| defined(WIN32) || defined(_WIN64) || defined(WIN64) || defined(_WIN32_WINNT) 93 #define OCILIB_MAJOR_VERSION 4 94 #define OCILIB_MINOR_VERSION 6 95 #define OCILIB_REVISION_VERSION 3 99 #define OCI_IMPORT_MODE_LINKAGE 1 100 #define OCI_IMPORT_MODE_RUNTIME 2 102 #ifdef OCI_IMPORT_RUNTIME 103 #undef OCI_IMPORT_LINKAGE 106 #ifdef OCI_IMPORT_LINKAGE 107 #undef OCI_IMPORT_RUNTIME 110 #if !defined(OCI_IMPORT_RUNTIME) && !defined(OCI_IMPORT_LINKAGE) 111 #define OCI_IMPORT_LINKAGE 114 #ifdef OCI_IMPORT_RUNTIME 115 #define OCI_IMPORT_MODE OCI_IMPORT_MODE_RUNTIME 117 #define OCI_IMPORT_MODE OCI_IMPORT_MODE_LINKAGE 122 #ifdef OCI_CHARSET_UNICODE 123 #define OCI_CHARSET_WIDE 126 #ifdef OCI_CHARSET_WIDE 127 #undef OCI_CHARSET_ANSI 130 #ifdef OCI_CHARSET_ANSI 131 #undef OCI_CHARSET_ANSI 134 #if !defined(OCI_CHARSET_ANSI) && !defined(OCI_CHARSET_WIDE) 135 #define OCI_CHARSET_ANSI 142 #define OCI_API __stdcall 243 #if defined(__cplusplus) && defined(_MSC_VER) && (_MSC_VER < 1300) 249 #if defined(__cplusplus) && defined(_MSC_VER) && (_MSC_VER < 1300) 255 #define OCI_CHAR_ANSI 1 256 #define OCI_CHAR_WIDE 2 258 #ifdef OCI_CHARSET_ANSI 261 #define OCI_CHAR_TEXT OCI_CHAR_ANSI 263 typedef wchar_t otext;
264 #define OTEXT(x) L ## x 265 #define OCI_CHAR_TEXT OCI_CHAR_WIDE 276 OCI_EXPORT
int ocisprintf
284 OCI_EXPORT
char * ocistrdup
289 OCI_EXPORT
int ocistrcasecmp
295 OCI_EXPORT
wchar_t * ociwcsdup
300 OCI_EXPORT
int ociwcscasecmp
310 #define vsnprintf _vsnprintf 311 #define swprintf _snwprintf 317 #ifdef OCI_CHARSET_ANSI 318 #define ostrdup ocistrdup 319 #define ostrcpy strcpy 320 #define ostrncpy strncpy 321 #define ostrcat strcat 322 #define ostrncat strncat 323 #define ostrlen strlen 324 #define ostrcmp strcmp 325 #define ostrcasecmp ocistrcasecmp 326 #define osprintf ocisprintf 327 #define ostrtol strtol 328 #define osscanf sscanf 329 #define otoupper toupper 330 #define oisdigit isdigit 332 #define ostrdup ociwcsdup 333 #define ostrcpy wcscpy 334 #define ostrncpy wcsncpy 335 #define ostrcat wcscat 336 #define ostrncat wcsncat 337 #define ostrlen wcslen 338 #define ostrcmp wcscmp 339 #define ostrcasecmp ociwcscasecmp 340 #define osprintf swprintf 341 #define ostrtol wcstol 342 #define osscanf swscanf 343 #define otoupper towupper 344 #define oisdigit iswdigit 350 #define otextsize(s) (ostrlen(s) * sizeof(otext)) 968 unsigned char *p_bytes;
1032 #if defined(_LONGLONG) || defined(LONG_LONG_MAX) || defined(LLONG_MAX) || defined(__LONG_LONG_MAX__) 1037 typedef unsigned long long big_uint;
1039 #define OCI_BIG_UINT_ENABLED 1041 #elif defined(_WINDOWS) 1046 typedef unsigned __int64 big_uint;
1048 #define OCI_BIG_UINT_ENABLED 1053 typedef unsigned int big_uint;
1074 #define OCI_VER_MAJ(v) (unsigned int) ((v)/100) 1075 #define OCI_VER_MIN(v) (unsigned int) (((v)/10) - (((v)/100)*10)) 1076 #define OCI_VER_REV(v) (unsigned int) ((v) - (((v)/10)*10)) 1078 #define OCI_VER_MAKE(x, y, z) ((x)*100 + (y)*10 + z) 1082 #define OCI_8_0 OCI_VER_MAKE( 8, 0, 0) 1083 #define OCI_8_1 OCI_VER_MAKE( 8, 1, 0) 1084 #define OCI_9_0 OCI_VER_MAKE( 9, 0, 0) 1085 #define OCI_9_2 OCI_VER_MAKE( 9, 2, 0) 1086 #define OCI_10_1 OCI_VER_MAKE(10, 1, 0) 1087 #define OCI_10_2 OCI_VER_MAKE(10, 2, 0) 1088 #define OCI_11_1 OCI_VER_MAKE(11, 1, 0) 1089 #define OCI_11_2 OCI_VER_MAKE(11, 2, 0) 1090 #define OCI_12_1 OCI_VER_MAKE(12, 1, 0) 1091 #define OCI_12_2 OCI_VER_MAKE(12, 2, 0) 1092 #define OCI_18_1 OCI_VER_MAKE(18, 1, 0) 1093 #define OCI_18_2 OCI_VER_MAKE(18, 2, 0) 1094 #define OCI_18_3 OCI_VER_MAKE(18, 3, 0) 1095 #define OCI_18_4 OCI_VER_MAKE(18, 4, 0) 1096 #define OCI_18_5 OCI_VER_MAKE(18, 5, 0) 1097 #define OCI_19_3 OCI_VER_MAKE(19, 3, 0) 1101 #define OCI_ERR_ORACLE 1 1102 #define OCI_ERR_OCILIB 2 1103 #define OCI_ERR_WARNING 3 1107 #define OCI_ERR_NONE 0 1108 #define OCI_ERR_NOT_INITIALIZED 1 1109 #define OCI_ERR_LOADING_SHARED_LIB 2 1110 #define OCI_ERR_LOADING_SYMBOLS 3 1111 #define OCI_ERR_MULTITHREADED 4 1112 #define OCI_ERR_MEMORY 5 1113 #define OCI_ERR_NOT_AVAILABLE 6 1114 #define OCI_ERR_NULL_POINTER 7 1115 #define OCI_ERR_DATATYPE_NOT_SUPPORTED 8 1116 #define OCI_ERR_PARSE_TOKEN 9 1117 #define OCI_ERR_MAP_ARGUMENT 10 1118 #define OCI_ERR_OUT_OF_BOUNDS 11 1119 #define OCI_ERR_UNFREED_DATA 12 1120 #define OCI_ERR_MAX_BIND 13 1121 #define OCI_ERR_ATTR_NOT_FOUND 14 1122 #define OCI_ERR_MIN_VALUE 15 1123 #define OCI_ERR_NOT_COMPATIBLE 16 1124 #define OCI_ERR_STMT_STATE 17 1125 #define OCI_ERR_STMT_NOT_SCROLLABLE 18 1126 #define OCI_ERR_BIND_ALREADY_USED 19 1127 #define OCI_ERR_BIND_ARRAY_SIZE 20 1128 #define OCI_ERR_COLUMN_NOT_FOUND 21 1129 #define OCI_ERR_DIRPATH_STATE 22 1130 #define OCI_ERR_CREATE_OCI_ENVIRONMENT 23 1131 #define OCI_ERR_REBIND_BAD_DATATYPE 24 1132 #define OCI_ERR_TYPEINFO_DATATYPE 25 1133 #define OCI_ERR_ITEM_NOT_FOUND 26 1134 #define OCI_ERR_ARG_INVALID_VALUE 27 1135 #define OCI_ERR_XA_ENV_FROM_STRING 28 1136 #define OCI_ERR_XA_CONN_FROM_STRING 29 1137 #define OCI_ERR_BIND_EXTERNAL_NOT_ALLOWED 30 1139 #define OCI_ERR_COUNT 31 1144 #define OCI_MEM_ORACLE 1 1145 #define OCI_MEM_OCILIB 2 1146 #define OCI_MEM_ALL (OCI_MEM_ORACLE | OCI_MEM_OCILIB) 1150 #define OCI_BIND_BY_POS 0 1151 #define OCI_BIND_BY_NAME 1 1152 #define OCI_BIND_SIZE 6 1153 #define OCI_BIND_MAX 65535 1157 #define OCI_FETCH_SIZE 20 1158 #define OCI_PREFETCH_SIZE 20 1159 #define OCI_LONG_EXPLICIT 1 1160 #define OCI_LONG_IMPLICIT 2 1164 #define OCI_UNKNOWN 0 1168 #define OCI_CDT_NUMERIC 1 1169 #define OCI_CDT_DATETIME 3 1170 #define OCI_CDT_TEXT 4 1171 #define OCI_CDT_LONG 5 1172 #define OCI_CDT_CURSOR 6 1173 #define OCI_CDT_LOB 7 1174 #define OCI_CDT_FILE 8 1175 #define OCI_CDT_TIMESTAMP 9 1176 #define OCI_CDT_INTERVAL 10 1177 #define OCI_CDT_RAW 11 1178 #define OCI_CDT_OBJECT 12 1179 #define OCI_CDT_COLLECTION 13 1180 #define OCI_CDT_REF 14 1181 #define OCI_CDT_BOOLEAN 15 1185 #define OCI_ARG_SHORT 1 1186 #define OCI_ARG_USHORT 2 1187 #define OCI_ARG_INT 3 1188 #define OCI_ARG_UINT 4 1189 #define OCI_ARG_BIGINT 5 1190 #define OCI_ARG_BIGUINT 6 1191 #define OCI_ARG_DOUBLE 7 1192 #define OCI_ARG_DATETIME 8 1193 #define OCI_ARG_TEXT 9 1194 #define OCI_ARG_LOB 10 1195 #define OCI_ARG_FILE 11 1196 #define OCI_ARG_TIMESTAMP 12 1197 #define OCI_ARG_INTERVAL 13 1198 #define OCI_ARG_RAW 14 1199 #define OCI_ARG_OBJECT 15 1200 #define OCI_ARG_COLLECTION 16 1201 #define OCI_ARG_REF 17 1202 #define OCI_ARG_FLOAT 18 1203 #define OCI_ARG_NUMBER 19 1207 #define OCI_CST_SELECT 1 1208 #define OCI_CST_UPDATE 2 1209 #define OCI_CST_DELETE 3 1210 #define OCI_CST_INSERT 4 1211 #define OCI_CST_CREATE 5 1212 #define OCI_CST_DROP 6 1213 #define OCI_CST_ALTER 7 1214 #define OCI_CST_BEGIN 8 1215 #define OCI_CST_DECLARE 9 1216 #define OCI_CST_CALL 10 1217 #define OCI_CST_MERGE 16 1221 #define OCI_ENV_DEFAULT 0 1222 #define OCI_ENV_THREADED 1 1223 #define OCI_ENV_CONTEXT 2 1224 #define OCI_ENV_EVENTS 4 1228 #define OCI_SESSION_DEFAULT 0x00000000 1229 #define OCI_SESSION_SYSDBA 0x00000002 1230 #define OCI_SESSION_SYSOPER 0x00000004 1231 #define OCI_SESSION_SYSASM 0x00008000 1232 #define OCI_SESSION_SYSBKP 0x00020000 1233 #define OCI_SESSION_SYSDGD 0x00040000 1234 #define OCI_SESSION_SYSKMT 0x00080000 1235 #define OCI_SESSION_SYSRAC 0x00100000 1237 #define OCI_SESSION_XA 0x00000001 1238 #define OCI_SESSION_PRELIM_AUTH 0x00000008 1242 #define OCI_CNT_OBJECTS 1 1243 #define OCI_CNT_ROWS 2 1244 #define OCI_CNT_DATABASES 4 1245 #define OCI_CNT_ALL (OCI_CNT_OBJECTS | OCI_CNT_ROWS | OCI_CNT_DATABASES) 1249 #define OCI_ENT_STARTUP 1 1250 #define OCI_ENT_SHUTDOWN 2 1251 #define OCI_ENT_SHUTDOWN_ANY 3 1252 #define OCI_ENT_DROP_DATABASE 4 1253 #define OCI_ENT_DEREGISTER 5 1254 #define OCI_ENT_OBJECT_CHANGED 6 1258 #define OCI_ONT_INSERT 0x2 1259 #define OCI_ONT_UPDATE 0x4 1260 #define OCI_ONT_DELETE 0x8 1261 #define OCI_ONT_ALTER 0x10 1262 #define OCI_ONT_DROP 0x20 1263 #define OCI_ONT_GENERIC 0x40 1267 #define OCI_DB_SPM_START 1 1268 #define OCI_DB_SPM_MOUNT 2 1269 #define OCI_DB_SPM_OPEN 4 1270 #define OCI_DB_SPM_FULL (OCI_DB_SPM_START | OCI_DB_SPM_MOUNT | OCI_DB_SPM_OPEN) 1274 #define OCI_DB_SPF_DEFAULT 0 1275 #define OCI_DB_SPF_FORCE 1 1276 #define OCI_DB_SPF_RESTRICT 2 1280 #define OCI_DB_SDM_SHUTDOWN 1 1281 #define OCI_DB_SDM_CLOSE 2 1282 #define OCI_DB_SDM_DISMOUNT 4 1283 #define OCI_DB_SDM_FULL (OCI_DB_SDM_SHUTDOWN | OCI_DB_SDM_CLOSE | OCI_DB_SDM_DISMOUNT) 1287 #define OCI_DB_SDF_DEFAULT 0 1288 #define OCI_DB_SDF_TRANS 1 1289 #define OCI_DB_SDF_TRANS_LOCAL 2 1290 #define OCI_DB_SDF_IMMEDIATE 3 1291 #define OCI_DB_SDF_ABORT 4 1295 #define OCI_CSF_NONE 0 1296 #define OCI_CSF_DEFAULT 1 1297 #define OCI_CSF_NATIONAL 2 1301 #define OCI_SFM_DEFAULT 0 1302 #define OCI_SFM_SCROLLABLE 0x08 1306 #define OCI_SFD_ABSOLUTE 0x20 1307 #define OCI_SFD_RELATIVE 0x40 1311 #define OCI_BAM_EXTERNAL 1 1312 #define OCI_BAM_INTERNAL 2 1316 #define OCI_BDM_IN 1 1317 #define OCI_BDM_OUT 2 1318 #define OCI_BDM_IN_OUT (OCI_BDM_IN | OCI_BDM_OUT) 1322 #define OCI_CPF_NONE 0 1323 #define OCI_CPF_IS_IDENTITY 1 1324 #define OCI_CPF_IS_GEN_ALWAYS 2 1325 #define OCI_CPF_IS_GEN_BY_DEFAULT_ON_NULL 4 1326 #define OCI_CPF_IS_LPART 8 1327 #define OCI_CPF_IS_CONID 16 1331 #define OCI_CCI_NONE 0x00000000 1332 #define OCI_CCI_NLS_COMP 0x00003FFE 1333 #define OCI_CCI_NLS_SORT 0x00003FFD 1334 #define OCI_CCI_NLS_SORT_CI 0x00003FFC 1335 #define OCI_CCI_NLS_SORT_AI 0x00003FFB 1336 #define OCI_CCI_NLS_SORT_CS 0x00003FFA 1337 #define OCI_CCI_NLS_SORT_VAR1 0x00003FF9 1338 #define OCI_CCI_NLS_SORT_VAR1_CI 0x00003FF8 1339 #define OCI_CCI_NLS_SORT_VAR1_AI 0x00003FF7 1340 #define OCI_CCI_NLS_SORT_VAR1_CS 0x00003FF6 1341 #define OCI_CCI_BINARY 0x00003FFF 1342 #define OCI_CCI_BINARY_CI 0x00023FFF 1343 #define OCI_CCI_BINARY_AI 0x00013FFF 1348 #define OCI_NUM_UNSIGNED 2 1352 #define OCI_NUM_SHORT 4 1353 #define OCI_NUM_INT 8 1354 #define OCI_NUM_BIGINT 16 1355 #define OCI_NUM_FLOAT 32 1356 #define OCI_NUM_DOUBLE 64 1357 #define OCI_NUM_NUMBER 128 1359 #define OCI_NUM_USHORT (OCI_NUM_SHORT | OCI_NUM_UNSIGNED) 1360 #define OCI_NUM_UINT (OCI_NUM_INT | OCI_NUM_UNSIGNED) 1361 #define OCI_NUM_BIGUINT (OCI_NUM_BIGINT | OCI_NUM_UNSIGNED) 1365 #define OCI_TIMESTAMP 1 1366 #define OCI_TIMESTAMP_TZ 2 1367 #define OCI_TIMESTAMP_LTZ 3 1371 #define OCI_INTERVAL_YM 1 1372 #define OCI_INTERVAL_DS 2 1387 #define OCI_LOB_READONLY 1 1388 #define OCI_LOB_READWRITE 2 1397 #define OCI_SEEK_SET 1 1398 #define OCI_SEEK_END 2 1399 #define OCI_SEEK_CUR 3 1403 #define OCI_TIF_TABLE 1 1404 #define OCI_TIF_VIEW 2 1405 #define OCI_TIF_TYPE 3 1409 #define OCI_OBJ_PERSISTENT 1 1410 #define OCI_OBJ_TRANSIENT 2 1411 #define OCI_OBJ_VALUE 3 1415 #define OCI_COLL_VARRAY 1 1416 #define OCI_COLL_NESTED_TABLE 2 1417 #define OCI_COLL_INDEXED_TABLE 3 1421 #define OCI_POOL_CONNECTION 1 1422 #define OCI_POOL_SESSION 2 1426 #define OCI_AMS_READY 1 1427 #define OCI_AMS_WAITING 2 1428 #define OCI_AMS_PROCESSED 3 1429 #define OCI_AMS_EXPIRED 4 1433 #define OCI_ASD_BEFORE 2 1434 #define OCI_ASD_TOP 3 1438 #define OCI_AMV_IMMEDIATE 1 1439 #define OCI_AMV_ON_COMMIT 2 1443 #define OCI_ADM_BROWSE 1 1444 #define OCI_ADM_LOCKED 2 1445 #define OCI_ADM_REMOVE 3 1446 #define OCI_ADM_REMOVE_NODATA 4 1450 #define OCI_ADN_FIRST_MSG 1 1451 #define OCI_ADN_NEXT_TRANSACTION 2 1452 #define OCI_ADN_NEXT_MSG 3 1456 #define OCI_APM_BUFFERED 1 1457 #define OCI_APM_PERSISTENT 2 1458 #define OCI_APM_ALL (OCI_APM_BUFFERED | OCI_APM_PERSISTENT) 1462 #define OCI_AGM_NONE 0 1463 #define OCI_AGM_TRANSACTIONNAL 1 1467 #define OCI_AQT_NORMAL 0 1468 #define OCI_AQT_EXCEPTION 1 1469 #define OCI_AQT_NON_PERSISTENT 2 1473 #define OCI_DPR_COMPLETE 1 1474 #define OCI_DPR_ERROR 2 1475 #define OCI_DPR_FULL 3 1476 #define OCI_DPR_PARTIAL 4 1477 #define OCI_DPR_EMPTY 5 1481 #define OCI_DCM_DEFAULT 1 1482 #define OCI_DCM_FORCE 2 1486 #define OCI_SIZE_TRACE_ID 64 1487 #define OCI_SIZE_TRACE_MODULE 48 1488 #define OCI_SIZE_TRACE_ACTION 32 1489 #define OCI_SIZE_TRACE_INFO 64 1490 #define OCI_SIZE_TRACE_OPERATION 32 1494 #define OCI_TRC_IDENTITY 1 1495 #define OCI_TRC_MODULE 2 1496 #define OCI_TRC_ACTION 3 1497 #define OCI_TRC_DETAIL 4 1498 #define OCI_TRC_OPERATION 5 1502 #define OCI_NTO_SEND 1 1503 #define OCI_NTO_RECEIVE 2 1504 #define OCI_NTO_CALL 3 1508 #define OCI_HET_DOWN 0 1509 #define OCI_HET_UP 1 1512 #define OCI_HES_INSTANCE 0 1513 #define OCI_HES_DATABASE 1 1514 #define OCI_HES_NODE 2 1515 #define OCI_HES_SERVICE 3 1516 #define OCI_HES_SERVICE_MEMBER 4 1517 #define OCI_HES_ASM_INSTANCE 5 1518 #define OCI_HES_PRECONNECT 6 1522 #define OCI_FOT_NONE 1 1523 #define OCI_FOT_SESSION 2 1524 #define OCI_FOT_SELECT 4 1528 #define OCI_FOE_END 1 1529 #define OCI_FOE_ABORT 2 1530 #define OCI_FOE_REAUTH 4 1531 #define OCI_FOE_BEGIN 8 1532 #define OCI_FOE_ERROR 16 1536 #define OCI_FOC_OK 0 1537 #define OCI_FOC_RETRY 25410 1541 #define OCI_HASH_STRING 1 1542 #define OCI_HASH_INTEGER 2 1543 #define OCI_HASH_POINTER 3 1547 #define OCI_TRS_NEW 0x00000001 1548 #define OCI_TRS_READONLY 0x00000100 1549 #define OCI_TRS_READWRITE 0x00000200 1550 #define OCI_TRS_SERIALIZABLE 0x00000400 1551 #define OCI_TRS_LOOSE 0x00010000 1552 #define OCI_TRS_TIGHT 0x00020000 1556 #define OCI_FMT_DATE 1 1557 #define OCI_FMT_TIMESTAMP 2 1558 #define OCI_FMT_NUMERIC 3 1559 #define OCI_FMT_BINARY_DOUBLE 4 1560 #define OCI_FMT_BINARY_FLOAT 5 1561 #define OCI_FMT_TIMESTAMP_TZ 6 1565 #define OCI_SFC_CREATE_TABLE 1 1566 #define OCI_SFC_INSERT 2 1567 #define OCI_SFC_SELECT 3 1568 #define OCI_SFC_CREATE_CLUSTER 4 1569 #define OCI_SFC_ALTER_CLUSTER 5 1570 #define OCI_SFC_UPDATE 6 1571 #define OCI_SFC_DELETE 7 1572 #define OCI_SFC_DROP_CLUSTER 8 1573 #define OCI_SFC_CREATE_INDEX 9 1574 #define OCI_SFC_DROP_INDEX 10 1575 #define OCI_SFC_ALTER_INDEX 11 1576 #define OCI_SFC_DROP_TABLE 12 1577 #define OCI_SFC_CREATE_SEQUENCE 13 1578 #define OCI_SFC_ALTER_SEQUENCE 14 1579 #define OCI_SFC_ALTER_TABLE 15 1580 #define OCI_SFC_DROP_SEQUENCE 16 1581 #define OCI_SFC_GRANT_OBJECT 17 1582 #define OCI_SFC_REVOKE_OBJECT 18 1583 #define OCI_SFC_CREATE_SYNONYM 19 1584 #define OCI_SFC_DROP_SYNONYM 20 1585 #define OCI_SFC_CREATE_VIEW 21 1586 #define OCI_SFC_DROP_VIEW 22 1587 #define OCI_SFC_VALIDATE_INDEX 23 1588 #define OCI_SFC_CREATE_PROCEDURE 24 1589 #define OCI_SFC_ALTER_PROCEDURE 25 1590 #define OCI_SFC_LOCK 26 1591 #define OCI_SFC_NO_OP 27 1592 #define OCI_SFC_RENAME 28 1593 #define OCI_SFC_COMMENT 29 1594 #define OCI_SFC_AUDIT_OBJECT 30 1595 #define OCI_SFC_NOAUDIT_OBJECT 31 1596 #define OCI_SFC_CREATE_DATABASE_LINK 32 1597 #define OCI_SFC_DROP_DATABASE_LINK 33 1598 #define OCI_SFC_CREATE_DATABASE 34 1599 #define OCI_SFC_ALTER_DATABASE 35 1600 #define OCI_SFC_CREATE_ROLLBACK_SEG 36 1601 #define OCI_SFC_ALTER_ROLLBACK_SEG 37 1602 #define OCI_SFC_DROP_ROLLBACK_SEG 38 1603 #define OCI_SFC_CREATE_TABLESPACE 39 1604 #define OCI_SFC_ALTER_TABLESPACE 40 1605 #define OCI_SFC_DROP_TABLESPACE 41 1606 #define OCI_SFC_ALTER_SESSION 42 1607 #define OCI_SFC_ALTER_USER 43 1608 #define OCI_SFC_COMMIT 44 1609 #define OCI_SFC_ROLLBACK 45 1610 #define OCI_SFC_SAVEPOINT 46 1611 #define OCI_SFC_PL_SQL_EXECUTE 47 1612 #define OCI_SFC_SET_TRANSACTION 48 1613 #define OCI_SFC_ALTER_SYSTEM 49 1614 #define OCI_SFC_EXPLAIN 50 1615 #define OCI_SFC_CREATE_USER 51 1616 #define OCI_SFC_CREATE_ROLE 52 1617 #define OCI_SFC_DROP_USER 53 1618 #define OCI_SFC_DROP_ROLE 54 1619 #define OCI_SFC_SET_ROLE 55 1620 #define OCI_SFC_CREATE_SCHEMA 56 1621 #define OCI_SFC_CREATE_CONTROL_FILE 57 1622 #define OCI_SFC_ALTER_TRACING 58 1623 #define OCI_SFC_CREATE_TRIGGER 59 1624 #define OCI_SFC_ALTER_TRIGGER 60 1625 #define OCI_SFC_DROP_TRIGGER 61 1626 #define OCI_SFC_ANALYZE_TABLE 62 1627 #define OCI_SFC_ANALYZE_INDEX 63 1628 #define OCI_SFC_ANALYZE_CLUSTER 64 1629 #define OCI_SFC_CREATE_PROFILE 65 1630 #define OCI_SFC_DROP_PROFILE 66 1631 #define OCI_SFC_ALTER_PROFILE 67 1632 #define OCI_SFC_DROP_PROCEDURE 68 1633 #define OCI_SFC_ALTER_RESOURCE_COST 70 1634 #define OCI_SFC_CREATE_MATERIALIZED_VIEW_LOG 71 1635 #define OCI_SFC_ALTER_MATERIALIZED_VIEW_LOG 72 1636 #define OCI_SFC_DROP_MATERIALIZED_VIEW_LOG 73 1637 #define OCI_SFC_CREATE_MATERIALIZED_VIEW 74 1638 #define OCI_SFC_ALTER_MATERIALIZED_VIEW 75 1639 #define OCI_SFC_DROP_MATERIALIZED_VIEW 76 1640 #define OCI_SFC_CREATE_TYPE 77 1641 #define OCI_SFC_DROP_TYPE 78 1642 #define OCI_SFC_ALTER_ROLE 79 1643 #define OCI_SFC_ALTER_TYPE 80 1644 #define OCI_SFC_CREATE_TYPE_BODY 81 1645 #define OCI_SFC_ALTER_TYPE_BODY 82 1646 #define OCI_SFC_DROP_TYPE_BODY 83 1647 #define OCI_SFC_DROP_LIBRARY 84 1648 #define OCI_SFC_TRUNCATE_TABLE 85 1649 #define OCI_SFC_TRUNCATE_CLUSTER 86 1650 #define OCI_SFC_ALTER_VIEW 88 1651 #define OCI_SFC_SET_CONSTRAINTS 90 1652 #define OCI_SFC_CREATE_FUNCTION 91 1653 #define OCI_SFC_ALTER_FUNCTION 92 1654 #define OCI_SFC_DROP_FUNCTION 93 1655 #define OCI_SFC_CREATE_PACKAGE 94 1656 #define OCI_SFC_ALTER_PACKAGE 95 1657 #define OCI_SFC_DROP_PACKAGE 96 1658 #define OCI_SFC_CREATE_PACKAGE_BODY 97 1659 #define OCI_SFC_ALTER_PACKAGE_BODY 98 1660 #define OCI_SFC_DROP_PACKAGE_BODY 99 1661 #define OCI_SFC_LOGON 100 1662 #define OCI_SFC_LOGOFF 101 1663 #define OCI_SFC_LOGOFF_BY_CLEANUP 102 1664 #define OCI_SFC_SESSION_REC 103 1665 #define OCI_SFC_SYSTEM_AUDIT 104 1666 #define OCI_SFC_SYSTEM_NOAUDIT 105 1667 #define OCI_SFC_AUDIT_DEFAULT 106 1668 #define OCI_SFC_NOAUDIT_DEFAULT 107 1669 #define OCI_SFC_SYSTEM_GRANT 108 1670 #define OCI_SFC_SYSTEM_REVOKE 109 1671 #define OCI_SFC_CREATE_PUBLIC_SYNONYM 110 1672 #define OCI_SFC_DROP_PUBLIC_SYNONYM 111 1673 #define OCI_SFC_CREATE_PUBLIC_DATABASE_LINK 112 1674 #define OCI_SFC_DROP_PUBLIC_DATABASE_LINK 113 1675 #define OCI_SFC_GRANT_ROLE 114 1676 #define OCI_SFC_REVOKE_ROLE 115 1677 #define OCI_SFC_EXECUTE_PROCEDURE 116 1678 #define OCI_SFC_USER_COMMENT 117 1679 #define OCI_SFC_ENABLE_TRIGGER 118 1680 #define OCI_SFC_DISABLE_TRIGGER 119 1681 #define OCI_SFC_ENABLE_ALL_TRIGGERS 120 1682 #define OCI_SFC_DISABLE_ALL_TRIGGERS 121 1683 #define OCI_SFC_NETWORK_ERROR 122 1684 #define OCI_SFC_EXECUTE_TYPE 123 1685 #define OCI_SFC_READ_DIRECTORY 125 1686 #define OCI_SFC_WRITE_DIRECTORY 126 1687 #define OCI_SFC_FLASHBACK 128 1688 #define OCI_SFC_BECOME_USER 129 1689 #define OCI_SFC_ALTER_MINING_MODEL 130 1690 #define OCI_SFC_SELECT_MINING_MODEL 131 1691 #define OCI_SFC_CREATE_MINING_MODEL 133 1692 #define OCI_SFC_ALTER_PUBLIC_SYNONYM 134 1693 #define OCI_SFC_EXECUTE_DIRECTORY 135 1694 #define OCI_SFC_SQL_LOADER_DIRECT_PATH_LOAD 136 1695 #define OCI_SFC_DATAPUMP_DIRECT_PATH_UNLOAD 137 1696 #define OCI_SFC_DATABASE_STARTUP 138 1697 #define OCI_SFC_DATABASE_SHUTDOWN 139 1698 #define OCI_SFC_CREATE_SQL_TXLN_PROFILE 140 1699 #define OCI_SFC_ALTER_SQL_TXLN_PROFILE 141 1700 #define OCI_SFC_USE_SQL_TXLN_PROFILE 142 1701 #define OCI_SFC_DROP_SQL_TXLN_PROFILE 143 1702 #define OCI_SFC_CREATE_MEASURE_FOLDER 144 1703 #define OCI_SFC_ALTER_MEASURE_FOLDER 145 1704 #define OCI_SFC_DROP_MEASURE_FOLDER 146 1705 #define OCI_SFC_CREATE_CUBE_BUILD_PROCESS 147 1706 #define OCI_SFC_ALTER_CUBE_BUILD_PROCESS 148 1707 #define OCI_SFC_DROP_CUBE_BUILD_PROCESS 149 1708 #define OCI_SFC_CREATE_CUBE 150 1709 #define OCI_SFC_ALTER_CUBE 151 1710 #define OCI_SFC_DROP_CUBE 152 1711 #define OCI_SFC_CREATE_CUBE_DIMENSION 153 1712 #define OCI_SFC_ALTER_CUBE_DIMENSION 154 1713 #define OCI_SFC_DROP_CUBE_DIMENSION 155 1714 #define OCI_SFC_CREATE_DIRECTORY 157 1715 #define OCI_SFC_DROP_DIRECTORY 158 1716 #define OCI_SFC_CREATE_LIBRARY 159 1717 #define OCI_SFC_CREATE_JAVA 160 1718 #define OCI_SFC_ALTER_JAVA 161 1719 #define OCI_SFC_DROP_JAVA 162 1720 #define OCI_SFC_CREATE_OPERATOR 163 1721 #define OCI_SFC_CREATE_INDEXTYPE 164 1722 #define OCI_SFC_DROP_INDEXTYPE 165 1723 #define OCI_SFC_ALTER_INDEXTYPE 166 1724 #define OCI_SFC_DROP_OPERATOR 167 1725 #define OCI_SFC_ASSOCIATE_STATISTICS 168 1726 #define OCI_SFC_DISASSOCIATE_STATISTICS 169 1727 #define OCI_SFC_CALL_METHOD 170 1728 #define OCI_SFC_CREATE_SUMMARY 171 1729 #define OCI_SFC_ALTER_SUMMARY 172 1730 #define OCI_SFC_DROP_SUMMARY 173 1731 #define OCI_SFC_CREATE_DIMENSION 174 1732 #define OCI_SFC_ALTER_DIMENSION 175 1733 #define OCI_SFC_DROP_DIMENSION 176 1734 #define OCI_SFC_CREATE_CONTEXT 177 1735 #define OCI_SFC_DROP_CONTEXT 178 1736 #define OCI_SFC_ALTER_OUTLINE 179 1737 #define OCI_SFC_CREATE_OUTLINE 180 1738 #define OCI_SFC_DROP_OUTLINE 181 1739 #define OCI_SFC_UPDATE_INDEXES 182 1740 #define OCI_SFC_ALTER_OPERATOR 183 1741 #define OCI_SFC_CREATE_SPFILE 187 1742 #define OCI_SFC_CREATE_PFILE 188 1743 #define OCI_SFC_MERGE 189 1744 #define OCI_SFC_PASSWORD_CHANGE 190 1745 #define OCI_SFC_ALTER_SYNONYM 192 1746 #define OCI_SFC_ALTER_DISKGROUP 193 1747 #define OCI_SFC_CREATE_DISKGROUP 194 1748 #define OCI_SFC_DROP_DISKGROUP 195 1749 #define OCI_SFC_PURGE_RECYCLEBIN 197 1750 #define OCI_SFC_PURGE_DBA_RECYCLEBIN 198 1751 #define OCI_SFC_PURGE_TABLESPACE 199 1752 #define OCI_SFC_PURGE_TABLE 200 1753 #define OCI_SFC_PURGE_INDEX 201 1754 #define OCI_SFC_UNDROP_OBJECT 202 1755 #define OCI_SFC_DROP_DATABASE 203 1756 #define OCI_SFC_FLASHBACK_DATABASE 204 1757 #define OCI_SFC_FLASHBACK_TABLE 205 1758 #define OCI_SFC_CREATE_RESTORE_POINT 206 1759 #define OCI_SFC_DROP_RESTORE_POINT 207 1760 #define OCI_SFC_PROXY_AUTHENTICATION_ONLY 208 1761 #define OCI_SFC_DECLARE_REWRITE_EQUIVALENCE 209 1762 #define OCI_SFC_ALTER_REWRITE_EQUIVALENCE 210 1763 #define OCI_SFC_DROP_REWRITE_EQUIVALENCE 211 1764 #define OCI_SFC_CREATE_EDITION 212 1765 #define OCI_SFC_ALTER_EDITION 213 1766 #define OCI_SFC_DROP_EDITION 214 1767 #define OCI_SFC_DROP_ASSEMBLY 215 1768 #define OCI_SFC_CREATE_ASSEMBLY 216 1769 #define OCI_SFC_ALTER_ASSEMBLY 217 1770 #define OCI_SFC_CREATE_FLASHBACK_ARCHIVE 218 1771 #define OCI_SFC_ALTER_FLASHBACK_ARCHIVE 219 1772 #define OCI_SFC_DROP_FLASHBACK_ARCHIVE 220 1773 #define OCI_SFC_DEBUG_CONNECT 221 1774 #define OCI_SFC_DEBUG_PROCEDURE 223 1775 #define OCI_SFC_ALTER_DATABASE_LINK 225 1776 #define OCI_SFC_CREATE_PLUGGABLE_DATABASE 226 1777 #define OCI_SFC_ALTER_PLUGGABLE_DATABASE 227 1778 #define OCI_SFC_DROP_PLUGGABLE_DATABASE 228 1779 #define OCI_SFC_CREATE_AUDIT_POLICY 229 1780 #define OCI_SFC_ALTER_AUDIT_POLICY 230 1781 #define OCI_SFC_DROP_AUDIT_POLICY 231 1782 #define OCI_SFC_CODE_BASED_GRANT 232 1783 #define OCI_SFC_CODE_BASED_REVOKE 233 1784 #define OCI_SFC_CREATE_LOCKDOWN_PROFILE 234 1785 #define OCI_SFC_DROP_LOCKDOWN_PROFILE 235 1786 #define OCI_SFC_ALTER_LOCKDOWN_PROFILE 236 1787 #define OCI_SFC_TRANSLATE_SQL 237 1788 #define OCI_SFC_ADMINISTER_KEY_MANAGEMENT 238 1789 #define OCI_SFC_CREATE_MATERIALIZED_ZONEMAP 239 1790 #define OCI_SFC_ALTER_MATERIALIZED_ZONEMAP 240 1791 #define OCI_SFC_DROP_MATERIALIZED_ZONEMAP 241 1792 #define OCI_SFC_DROP_MINING_MODEL 242 1793 #define OCI_SFC_CREATE_ATTRIBUTE_DIMENSION 243 1794 #define OCI_SFC_ALTER_ATTRIBUTE_DIMENSION 244 1795 #define OCI_SFC_DROP_ATTRIBUTE_DIMENSION 245 1796 #define OCI_SFC_CREATE_HIERARCHY 246 1797 #define OCI_SFC_ALTER_HIERARCHY 247 1798 #define OCI_SFC_DROP_HIERARCHY 248 1799 #define OCI_SFC_CREATE_ANALYTIC_VIEW 249 1800 #define OCI_SFC_ALTER_ANALYTIC_VIEW 250 1801 #define OCI_SFC_DROP_ANALYTIC_VIEW 251 1802 #define OCI_SFC_ALTER_PUBLIC_DATABASE_LINK 305 1808 #define OCI_SIZE_FORMAT 64 1809 #define OCI_SIZE_BUFFER 512 1810 #define OCI_SIZE_LONG ((64*1024)-1) 1811 #define OCI_SIZE_DATE 45 1812 #define OCI_SIZE_TIMESTAMP 54 1813 #define OCI_SIZE_FORMAT_TODATE 14 1814 #define OCI_SIZE_NULL 4 1815 #define OCI_SIZE_PRECISION 10 1816 #define OCI_SIZE_ROWID 23 1817 #define OCI_SIZE_DIRECTORY 30 1818 #define OCI_SIZE_FILENAME 255 1819 #define OCI_SIZE_FORMAT_NUMS 40 1820 #define OCI_SIZE_FORMAT_NUML 65 1821 #define OCI_SIZE_OBJ_NAME 128 1823 #define OCI_HASH_DEFAULT_SIZE 256 1827 #define OCILIB_DRIVER_NAME OTEXT("OCILIB") 1828 #define OCI_STRING_NULL OTEXT("NULL") 1829 #define OCI_STRING_EMPTY OTEXT("") 1830 #define OCI_STRING_FORMAT_DATE OTEXT("YYYY-MM-DD") 1831 #define OCI_STRING_FORMAT_TIME OTEXT("HH24:MI:SS") 1832 #define OCI_STRING_FORMAT_DATETIME OTEXT("YYYY-MM-DD HH24:MI:SS") 1833 #define OCI_STRING_FORMAT_TIMESTAMP OTEXT("YYYY-MM-DD HH24:MI:SS.FF") 1834 #define OCI_STRING_FORMAT_TIMESTAMP_TZ OTEXT("YYYY-MM-DD HH24:MI:SS.FF TZR") 1835 #define OCI_STRING_DEFAULT_PREC 3 1836 #define OCI_STRING_FORMAT_NUM \ 1837 OTEXT("FM99999999999999999999999999999999999990.999999999999999999999999") 1838 #define OCI_STRING_FORMAT_NUM_BDOUBLE OTEXT("%lf") 1839 #define OCI_STRING_FORMAT_NUM_BFLOAT OTEXT("%f") 1840 #define OCI_STRING_FORMAT_NUM_SHORT OTEXT("%hd") 1841 #define OCI_STRING_FORMAT_NUM_INT OTEXT("%d") 1842 #define OCI_STRING_TRUE OTEXT("TRUE") 1843 #define OCI_STRING_FALSE OTEXT("FALSE") 1844 #define OCI_STRING_TRUE_SIZE 4 1845 #define OCI_STRING_FALSE_SIZE 5 1848 #define OCI_CHAR_SLASH '\\' 1850 #define OCI_CHAR_SLASH '/' 1918 const otext *lib_path,
2023 unsigned int mem_type
2518 const otext *password
2540 const otext *new_pwd
2847 OCI_EXPORT
boolean OCI_API
OCI_Ping 3294 unsigned int min_con,
3295 unsigned int max_con,
3296 unsigned int incr_con
3669 unsigned int timeout,
4499 unsigned short *data
4527 unsigned short *data,
5618 unsigned int direction
5838 unsigned int position,
5882 unsigned int position
5935 unsigned int position
5988 unsigned int position
6026 unsigned int position
6993 void *row_struct_ind
8059 unsigned int bufsize,
8060 unsigned int arrsize,
8337 unsigned int nb_elem
9041 unsigned short value
10348 unsigned int nbelem
10496 unsigned int *char_count,
10497 unsigned int *byte_count
10557 unsigned int *char_count,
10558 unsigned int *byte_count
10706 unsigned int *char_count,
10707 unsigned int *byte_count
10767 big_uint offset_dst,
10768 big_uint offset_src,
10796 big_uint offset_dst,
10797 big_uint offset_src,
11079 unsigned int nbelem
11614 unsigned int nbelem
11745 unsigned char *content
11994 unsigned int nbelem
12379 const otext *zone1,
12520 unsigned int nbelem
12649 const otext *time_zone
13021 unsigned int nbelem
13411 unsigned int nbelem
14088 unsigned short value
14538 unsigned int *size,
14600 unsigned int nbelem
15852 const otext *partition,
15853 unsigned int nb_cols,
15854 unsigned int nb_rows
15896 unsigned int index,
15898 unsigned int maxsize,
15899 const otext *format
15963 unsigned int index,
16154 unsigned int nb_rows
16212 const otext *format
17039 const otext *correlation
17197 unsigned int sequence
17239 unsigned int visibility
17414 unsigned int timeout,
17453 const otext *consumer
17491 const otext *pattern
17583 unsigned int visibility
17682 unsigned int position
17821 const otext *address
17905 const otext *address
17971 const otext *queue_name,
17972 const otext *queue_table,
17973 unsigned int queue_type,
17974 unsigned int max_retries,
17975 unsigned int retry_delay,
17976 unsigned int retention_time,
17977 boolean dependency_tracking,
17978 const otext *comment
18011 const otext *queue_name,
18012 unsigned int max_retries,
18013 unsigned int retry_delay,
18014 unsigned int retention_time,
18015 const otext *comment
18040 const otext *queue_name
18067 const otext *queue_name,
18097 const otext *queue_name,
18159 const otext *queue_table,
18160 const otext *queue_payload_type,
18161 const otext *storage_clause,
18162 const otext *sort_list,
18163 boolean multiple_consumers,
18164 unsigned int message_grouping,
18165 const otext *comment,
18166 unsigned int primary_instance,
18167 unsigned int secondary_instance,
18168 const otext *compatible
18196 const otext *queue_table,
18197 const otext *comment,
18198 unsigned int primary_instance,
18199 unsigned int secondary_instance
18229 const otext *queue_table,
18269 const otext *queue_table,
18270 const otext *purge_condition,
18272 unsigned int delivery_mode
18299 const otext *queue_table,
18300 const otext *compatible
18419 unsigned int timeout
18758 unsigned int sess_mode,
18759 unsigned int start_mode,
18760 unsigned int start_flag,
18761 const otext *spfile
18823 unsigned int sess_mode,
18824 unsigned int shut_mode,
18825 unsigned int shut_flag
19237 #define VAR_OCILIB_WORKAROUND_UTF16_COLUMN_NAME "OCILIB_WORKAROUND_UTF16_COLUMN_NAME" 19260 #define OCI_CreateConnection OCI_ConnectionCreate 19261 #define OCI_FreeConnection OCI_ConnectionFree 19262 #define OCI_CreateStatement OCI_StatementCreate 19263 #define OCI_FreeStatement OCI_StatementFree 19267 #define OCI_CreateTransaction OCI_TransactionCreate 19268 #define OCI_FreeTransaction OCI_TransactionFree 19269 #define OCI_CreateHashTable OCI_HashCreate 19270 #define OCI_FreeHashTable OCI_HashFree 19274 #define OCI_GetColumnName OCI_ColumnGetName 19275 #define OCI_GetColumnType OCI_ColumnGetType 19276 #define OCI_GetColumnCharsetForm OCI_ColumnGetCharsetForm 19277 #define OCI_GetColumnSQLType OCI_ColumnGetSQLType 19278 #define OCI_GetColumnFullSQLType OCI_ColumnGetFullSQLType 19279 #define OCI_GetColumnSize OCI_ColumnGetSize 19280 #define OCI_GetColumnScale OCI_ColumnGetScale 19281 #define OCI_GetColumnPrecision OCI_ColumnGetPrecision 19282 #define OCI_GetColumnFractionnalPrecision OCI_ColumnGetFractionnalPrecision 19283 #define OCI_GetColumnLeadingPrecision OCI_ColumnGetLeadingPrecision 19284 #define OCI_GetColumnNullable OCI_ColumnGetNullable 19285 #define OCI_GetColumnCharUsed OCI_ColumnGetCharUsed 19287 #define OCI_GetFormatDate(s) OCI_GetDefaultFormatDate(OCI_StatementGetConnection(s)) 19288 #define OCI_SetFormatDate(s, f) OCI_SetDefaultFormatDate(OCI_StatementGetConnection(s), f) 19290 #define OCI_ERR_API OCI_ERR_ORACLE 19294 #define OCI_ERR_NOT_SUPPORTED OCI_ERR_DATATYPE_NOT_SUPPORTED 19295 #define OCI_SCHEMA_TABLE OCI_TIF_TABLE 19296 #define OCI_SCHEMA_VIEW OCI_TIF_VIEW 19297 #define OCI_SCHEMA_TYPE OCI_TIF_TYPE 19299 #define OCI_Schema OCI_TypeInfo 19301 #define OCI_SchemaGet OCI_TypeInfoGet 19302 #define OCI_SchemaFree OCI_TypeInfoFree 19303 #define OCI_SchemaGetColumnCount OCI_TypeInfoGetColumnCount 19304 #define OCI_SchemaGetColumn OCI_TypeInfoGetColumn 19305 #define OCI_SchemaGetName OCI_TypeInfoGetName 19307 #define OCI_ColumnGetFractionnalPrecision OCI_ColumnGetFractionalPrecision 19311 #define OCI_SetNull(stmt, index) \ 19312 OCI_BindSetNull(OCI_GetBind(stmt, index)) 19314 #define OCI_SetNull2(stmt, name) \ 19315 OCI_BindSetNull(OCI_GetBind2(stmt, name)) 19317 #define OCI_SetNullAtPos(stmt, index, position) \ 19318 OCI_BindSetNullAtPos(OCI_GetBind(stmt, index), position) 19320 #define OCI_SetNullAtPos2(stmt, name, position) \ 19321 OCI_BindSetNullAtPos(OCI_GetBind2(stmt, name), position) 19325 #define OCI_8 OCI_8_1 19326 #define OCI_9 OCI_9_0 19327 #define OCI_10 OCI_10_1 19328 #define OCI_11 OCI_11_1 19332 #define OCI_CHAR_UNICODE OCI_CHAR_WIDE 19333 #define OCI_CSF_CHARSET OCI_CSF_DEFAULT 19337 #define OCI_ConnPool OCI_Pool 19339 #define OCI_ConnPoolCreate(db, us, pw, mo, mi, ma, in) \ 19340 OCI_PoolCreate(db, us, pw, OCI_POOL_CONNECTION, mo, mi, ma, in) 19342 #define OCI_ConnPoolGetConnection(p) \ 19343 OCI_PoolGetConnection(p, NULL) 19345 #define OCI_ConnPoolFree OCI_PoolFree 19346 #define OCI_ConnPoolGetTimeout OCI_PoolGetConnection 19347 #define OCI_ConnPoolSetTimeout OCI_PoolSetTimeout 19348 #define OCI_ConnPoolGetNoWait OCI_PoolGetNoWait 19349 #define OCI_ConnPoolSetNoWait OCI_PoolSetNoWait 19350 #define OCI_ConnPoolGetBusyCount OCI_PoolGetBusyCount 19351 #define OCI_ConnPoolGetOpenedCount OCI_PoolGetOpenedCount 19352 #define OCI_ConnPoolGetMin OCI_PoolGetMin 19353 #define OCI_ConnPoolGetMax OCI_PoolGetMax 19354 #define OCI_ConnPoolGetIncrement OCI_PoolGetIncrement 19358 #define OCI_ObjectGetTimeStamp OCI_ObjectGetTimestamp 19359 #define OCI_ElemGetTimeStamp OCI_ElemGetTimestamp 19360 #define OCI_TimestampSysTimeStamp OCI_TimestampSysTimestamp 19364 #define OCI_CollSetAt OCI_CollSetElem 19365 #define OCI_CollGetAt OCI_CollGetElem 19366 #define OCI_CollGetAt2 OCI_CollGetElem2 19368 #define OCI_GetCharsetMetaData OCI_GetCharset 19369 #define OCI_GetCharsetUserData OCI_GetCharset 19370 #define OCI_SIZE_TRACE_INF0 OCI_SIZE_TRACE_INFO 19372 #define MT(x) OTEXT(x) 19373 #define mtext otext 19374 #define DT(x) OTEXT(x) 19375 #define dtext otext 19377 #define mtsdup ostrdup 19378 #define mtscpy ostrcpy 19379 #define mtsncpy ostrncpy 19380 #define mtscat ostrcat 19381 #define mtsncat ostrncat 19382 #define mtslen ostrlen 19383 #define mtscmp ostrcmp 19384 #define mtscasecmp ostrcasecmp 19385 #define mtsprintf osprintf 19386 #define mtstol ostrtol 19387 #define mtsscanf osscanf 19389 #define dtsdup ostrdup 19390 #define dtscpy ostrcpy 19391 #define dtsncpy ostrncpy 19392 #define dtscat ostrcat 19393 #define dtsncat ostrncat 19394 #define dtslen ostrlen 19395 #define dtscmp ostrcmp 19396 #define dtscasecmp ostrcasecmp 19397 #define dtsprintf osprintf 19398 #define dtstol ostrtol 19399 #define dtsscanf osscanf 19403 #define OCI_SetDefaultFormatDate(con, fmt) OCI_SetFormat(con, OCI_FMT_DATE, fmt) 19404 #define OCI_SetDefaultFormatNumeric(con, fmt) OCI_SetFormat(con, OCI_FMT_NUMERIC, fmt) 19406 #define OCI_GetDefaultFormatDate(con) OCI_GetFormat(con, OCI_FMT_DATE) 19407 #define OCI_GetDefaultFormatNumeric(con) OCI_GetFormat(con, OCI_FMT_NUMERIC) 19409 #define OCI_STRING_FORMAT_NUM_BIN OCI_STRING_FORMAT_NUM_BDOUBLE OCI_EXPORT boolean OCI_API OCI_LobRead2(OCI_Lob *lob, void *buffer, unsigned int *char_count, unsigned int *byte_count)
Read a portion of a lob into the given buffer.
OCI_EXPORT const void *OCI_API OCI_HandleGetMutex(OCI_Mutex *mutex)
Return OCI Mutex handle (OCIThreadMutex *) of an OCILIB OCI_Mutex object.
OCI_EXPORT OCI_Subscription *OCI_API OCI_EventGetSubscription(OCI_Event *event)
Return the subscription handle that generated this event.
OCI_EXPORT boolean OCI_API OCI_ObjectSetFile(OCI_Object *obj, const otext *attr, OCI_File *value)
Set an object attribute of type File.
OCI_EXPORT boolean OCI_API OCI_BindUnsignedBigInt(OCI_Statement *stmt, const otext *name, big_uint *data)
Bind an unsigned big integer variable.
struct OCI_Mutex OCI_Mutex
OCILIB encapsulation of OCI mutexes.
struct OCI_Agent OCI_Agent
OCILIB encapsulation of A/Q Agent.
OCI_EXPORT unsigned int OCI_API OCI_GetLongMode(OCI_Statement *stmt)
Return the long data type handling mode of a SQL statement.
OCI_EXPORT boolean OCI_API OCI_CollArrayFree(OCI_Coll **colls)
Free an array of Collection objects.
OCI_EXPORT unsigned int OCI_API OCI_EnqueueGetVisibility(OCI_Enqueue *enqueue)
Get the enqueuing/locking behavior.
OCI_EXPORT OCI_Column *OCI_API OCI_GetColumn(OCI_Resultset *rs, unsigned int index)
Return the column object handle at the given index in the resultset.
OCI_EXPORT int OCI_API OCI_ErrorGetInternalCode(OCI_Error *err)
Retrieve Internal Error code from error handle.
OCI_EXPORT big_int OCI_API OCI_ElemGetBigInt(OCI_Elem *elem)
Return the big int value of the given collection element.
OCI_EXPORT const otext *OCI_API OCI_GetVersionServer(OCI_Connection *con)
Return the connected database server version.
OCI_EXPORT boolean OCI_API OCI_ObjectArrayFree(OCI_Object **objs)
Free an array of Object objects.
OCI_EXPORT boolean OCI_API OCI_DateLastDay(OCI_Date *date)
Place the last day of month (from the given date) into the given date.
OCI_EXPORT boolean OCI_API OCI_MsgGetID(OCI_Msg *msg, void *id, unsigned int *len)
Return the ID of the message.
OCI_EXPORT big_uint OCI_API OCI_GetAllocatedBytes(unsigned int mem_type)
Return the current number of bytes allocated internally in the library.
OCI_EXPORT boolean OCI_API OCI_ConnectionFree(OCI_Connection *con)
Close a physical connection to an Oracle database server.
OCI_EXPORT boolean OCI_API OCI_QueueStart(OCI_Connection *con, const otext *queue_name, boolean enqueue, boolean dequeue)
Start the given queue.
unsigned int(* POCI_TAF_HANDLER)(OCI_Connection *con, unsigned int type, unsigned int event)
Failover Notification User callback prototype.
OCI_EXPORT boolean OCI_API OCI_DequeueSubscribe(OCI_Dequeue *dequeue, unsigned int port, unsigned int timeout, POCI_NOTIFY_AQ callback)
Subscribe for asynchronous messages notifications.
OCI_EXPORT const otext *OCI_API OCI_ServerGetOutput(OCI_Connection *con)
Retrieve one line of the server buffer.
OCI_EXPORT boolean OCI_API OCI_ColumnGetCharUsed(OCI_Column *col)
Return TRUE if the length of the column is character-length or FALSE if it is byte-length.
OCI_EXPORT boolean OCI_API OCI_SubscriptionUnregister(OCI_Subscription *sub)
Unregister a previously registered notification.
long long big_int
big_int is a C scalar integer (32 or 64 bits) depending on compiler support for 64bits integers...
OCI_EXPORT unsigned int OCI_API OCI_LobGetType(OCI_Lob *lob)
Return the type of the given Lob object.
OCI_EXPORT boolean OCI_API OCI_CollClear(OCI_Coll *coll)
clear all items of the given collection
OCI_EXPORT OCI_Object *OCI_API OCI_ObjectCreate(OCI_Connection *con, OCI_TypeInfo *typinf)
Create a local object instance.
OCI_EXPORT boolean OCI_API OCI_BindSetNullAtPos(OCI_Bind *bnd, unsigned int position)
Set to null the entry in the bind variable input array.
OCI_EXPORT unsigned int OCI_API OCI_MsgGetState(OCI_Msg *msg)
Return the state of the message at the time of the dequeue.
OCI_EXPORT boolean OCI_API OCI_ElemSetNull(OCI_Elem *elem)
Set a collection element value to null.
OCI_EXPORT boolean OCI_API OCI_ObjectSetLob(OCI_Object *obj, const otext *attr, OCI_Lob *value)
Set an object attribute of type Lob.
OCI_EXPORT boolean OCI_API OCI_ExecuteStmt(OCI_Statement *stmt, const otext *sql)
Prepare and Execute a SQL statement or PL/SQL block.
OCI_EXPORT boolean OCI_API OCI_ObjectSetNull(OCI_Object *obj, const otext *attr)
Set an object attribute to null.
OCI_EXPORT OCI_Column *OCI_API OCI_GetColumn2(OCI_Resultset *rs, const otext *name)
Return the column object handle from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_DateAddDays(OCI_Date *date, int nb)
Add or subtract days to a date handle.
OCI_EXPORT boolean OCI_API OCI_RegisterUnsignedShort(OCI_Statement *stmt, const otext *name)
Register an unsigned short output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_RegisterUnsignedBigInt(OCI_Statement *stmt, const otext *name)
Register an unsigned big integer output bind placeholder.
OCI_EXPORT unsigned int OCI_API OCI_FileGetType(OCI_File *file)
Return the type of the given File object.
OCI_EXPORT boolean OCI_API OCI_EnqueueSetRelativeMsgID(OCI_Enqueue *enqueue, const void *id, unsigned int len)
Set a message identifier to use for enqueuing messages using a sequence deviation.
OCI_EXPORT boolean OCI_API OCI_RegisterFile(OCI_Statement *stmt, const otext *name, unsigned int type)
Register a file output bind placeholder.
OCI_EXPORT unsigned int OCI_API OCI_GetPrefetchSize(OCI_Statement *stmt)
Return the number of rows pre-fetched by OCI Client.
OCI_EXPORT boolean OCI_API OCI_RegisterDate(OCI_Statement *stmt, const otext *name)
Register a date output bind placeholder.
OCI_EXPORT unsigned int OCI_API OCI_GetDataSize(OCI_Resultset *rs, unsigned int index)
Return the size of the value of the column at the given index in the resultset.
OCI_EXPORT OCI_Statement *OCI_API OCI_StatementCreate(OCI_Connection *con)
Create a statement object and return its handle.
OCI_EXPORT boolean OCI_API OCI_ServerDisableOutput(OCI_Connection *con)
Disable the server output.
OCI_EXPORT boolean OCI_API OCI_BindUnsignedInt(OCI_Statement *stmt, const otext *name, unsigned int *data)
Bind an unsigned integer variable.
OCI_EXPORT boolean OCI_API OCI_RefSetNull(OCI_Ref *ref)
Nullify the given Ref handle.
struct OCI_Connection OCI_Connection
Oracle physical connection.
OCI_EXPORT int OCI_API OCI_ObjectGetInt(OCI_Object *obj, const otext *attr)
Return the integer value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_ThreadRun(OCI_Thread *thread, POCI_THREAD proc, void *arg)
Execute the given routine within the given thread object.
OCI_EXPORT unsigned int OCI_API OCI_LongRead(OCI_Long *lg, void *buffer, unsigned int len)
Read a portion of a long into the given buffer [Obsolete].
OCI_EXPORT unsigned int OCI_API OCI_GetLongMaxSize(OCI_Statement *stmt)
Return the LONG data type piece buffer size.
OCI_EXPORT unsigned int OCI_API OCI_GetBindAllocation(OCI_Statement *stmt)
Return the current bind allocation mode used for subsequent binding calls.
OCI_EXPORT boolean OCI_API OCI_BindSetNotNullAtPos(OCI_Bind *bnd, unsigned int position)
Set to NOT null the entry in the bind variable input array.
OCI_EXPORT unsigned int OCI_API OCI_IntervalGetType(OCI_Interval *itv)
Return the type of the given Interval object.
OCI_EXPORT boolean OCI_API OCI_DequeueFree(OCI_Dequeue *dequeue)
Free a Dequeue object.
OCI_EXPORT OCI_Connection *OCI_API OCI_ErrorGetConnection(OCI_Error *err)
Retrieve connection handle within the error occurred.
OCI_EXPORT boolean OCI_API OCI_NumberGetValue(OCI_Number *number, unsigned int type, void *value)
Assign the number value to a native C numeric type.
OCI_EXPORT boolean OCI_API OCI_FileAssign(OCI_File *file, OCI_File *file_src)
Assign a file to another one.
OCI_EXPORT boolean OCI_API OCI_DateFromText(OCI_Date *date, const otext *str, const otext *fmt)
Convert a string to a date and store it in the given date handle.
OCI_EXPORT const otext *OCI_API OCI_GetUserName(OCI_Connection *con)
Return the current logged user name.
OCI_EXPORT const otext *OCI_API OCI_ColumnGetSQLType(OCI_Column *col)
Return the Oracle SQL type name of the column data type.
OCI_EXPORT boolean OCI_API OCI_PoolSetStatementCacheSize(OCI_Pool *pool, unsigned int value)
Set the maximum number of statements to keep in the pool statement cache.
OCI_EXPORT boolean OCI_API OCI_DequeueSetWaitTime(OCI_Dequeue *dequeue, int timeout)
set the time that OCIDequeueGet() waits for messages if no messages are currently available ...
OCI_EXPORT boolean OCI_API OCI_FetchPrev(OCI_Resultset *rs)
Fetch the previous row of the resultset.
OCI_EXPORT boolean OCI_API OCI_DequeueSetNavigation(OCI_Dequeue *dequeue, unsigned int position)
Set the position of messages to be retrieved.
OCI_EXPORT boolean OCI_API OCI_IsNull(OCI_Resultset *rs, unsigned int index)
Check if the current row value is null for the column at the given index in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_ElemGetUnsignedInt(OCI_Elem *elem)
Return the unsigned int value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_SetUserPassword(const otext *db, const otext *user, const otext *pwd, const otext *new_pwd)
Change the password of the given user on the given database.
OCI_EXPORT boolean OCI_API OCI_ObjectSetRaw(OCI_Object *obj, const otext *attr, void *value, unsigned int len)
Set an object attribute of type RAW.
OCI_EXPORT const otext *OCI_API OCI_ObjectGetString(OCI_Object *obj, const otext *attr)
Return the string value of the given object attribute.
OCI_EXPORT big_uint OCI_API OCI_LobGetOffset(OCI_Lob *lob)
Return the current position in the Lob content buffer.
OCI_EXPORT boolean OCI_API OCI_IntervalSubtract(OCI_Interval *itv, OCI_Interval *itv2)
Subtract an interval handle value from another.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetFullSQLType(OCI_Column *col, otext *buffer, unsigned int len)
Return the Oracle SQL Full name including precision and size of the column data type.
OCI_EXPORT double OCI_API OCI_ObjectGetDouble(OCI_Object *obj, const otext *attr)
Return the double value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_BindString(OCI_Statement *stmt, const otext *name, otext *data, unsigned int len)
Bind a string variable.
OCI_EXPORT unsigned int OCI_API OCI_ObjectGetType(OCI_Object *obj)
Return the type of an object instance.
OCI_EXPORT OCI_Enqueue *OCI_API OCI_EnqueueCreate(OCI_TypeInfo *typinf, const otext *name)
Create a Enqueue object for the given queue.
OCI_EXPORT OCI_Elem *OCI_API OCI_ElemCreate(OCI_TypeInfo *typinf)
Create a local collection element instance based on a collection type descriptor. ...
OCI_EXPORT boolean OCI_API OCI_ElemSetRaw(OCI_Elem *elem, void *value, unsigned int len)
Set a RAW value to a collection element.
OCI_EXPORT void *OCI_API OCI_BindGetData(OCI_Bind *bnd)
Return the user defined data associated with a bind handle.
OCI_EXPORT const otext *OCI_API OCI_ColumnGetName(OCI_Column *col)
Return the name of the given column.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfUnsignedShorts(OCI_Statement *stmt, const otext *name, unsigned short *data, unsigned int nbelem)
Bind an array of unsigned shorts.
OCI_EXPORT int OCI_API OCI_ObjectGetRaw(OCI_Object *obj, const otext *attr, void *value, unsigned int len)
Return the raw attribute value of the given object attribute into the given buffer.
OCI_EXPORT boolean OCI_API OCI_BindArraySetSize(OCI_Statement *stmt, unsigned int size)
Set the input array size for bulk operations.
OCI_EXPORT OCI_File *OCI_API OCI_ElemGetFile(OCI_Elem *elem)
Return the File value of the given collection element.
OCI_EXPORT OCI_Connection *OCI_API OCI_PoolGetConnection(OCI_Pool *pool, const otext *tag)
Get a connection from the pool.
OCI_EXPORT unsigned int OCI_API OCI_GetTimeout(OCI_Connection *con, unsigned int type)
Returns the requested timeout value for OCI calls that require server round-trips to the given databa...
OCI_EXPORT boolean OCI_API OCI_IntervalFromTimeZone(OCI_Interval *itv, const otext *str)
Correct an interval handle value with the given time zone.
OCI_EXPORT unsigned int OCI_API OCI_GetImportMode(void)
Return the Oracle shared library import mode.
OCI_EXPORT unsigned int OCI_API OCI_BindGetDirection(OCI_Bind *bnd)
Get the direction mode of a bind handle.
OCI_EXPORT OCI_Connection *OCI_API OCI_FileGetConnection(OCI_File *file)
Retrieve connection handle from the file handle.
OCI_EXPORT boolean OCI_API OCI_SetBindMode(OCI_Statement *stmt, unsigned int mode)
Set the binding mode of a SQL statement.
OCI_EXPORT boolean OCI_API OCI_ObjectToText(OCI_Object *obj, unsigned int *size, otext *str)
Convert an object handle value to a string.
OCI_EXPORT boolean OCI_API OCI_DequeueSetVisibility(OCI_Dequeue *dequeue, unsigned int visibility)
Set whether the new message is dequeued as part of the current transaction.
OCI_EXPORT OCI_Statement *OCI_API OCI_GetStatement(OCI_Resultset *rs, unsigned int index)
Return the current cursor value (Nested table) of the column at the given index in the resultset...
OCI_EXPORT boolean OCI_API OCI_FileExists(OCI_File *file)
Check if the given file exists on server.
OCI_EXPORT boolean OCI_API OCI_FetchLast(OCI_Resultset *rs)
Fetch the last row of the resultset.
OCI_EXPORT OCI_Elem *OCI_API OCI_IterGetCurrent(OCI_Iter *iter)
Get the current element in the collection.
OCI_EXPORT boolean OCI_API OCI_ObjectSetShort(OCI_Object *obj, const otext *attr, short value)
Set an object attribute of type short.
OCI_EXPORT boolean OCI_API OCI_BindStatement(OCI_Statement *stmt, const otext *name, OCI_Statement *data)
Bind a Statement variable (PL/SQL Ref Cursor)
OCI_EXPORT boolean OCI_API OCI_DateAddMonths(OCI_Date *date, int nb)
Add or subtract months to a date handle.
OCI_EXPORT const void *OCI_API OCI_HandleGetStatement(OCI_Statement *stmt)
Return the OCI Statement Handle (OCIStmt *) of an OCILIB OCI_Statement object.
OCI_EXPORT boolean OCI_API OCI_MutexAcquire(OCI_Mutex *mutex)
Acquire a mutex lock.
OCI_EXPORT boolean OCI_API OCI_ElemSetString(OCI_Elem *elem, const otext *value)
Set a string value to a collection element.
OCI_EXPORT boolean OCI_API OCI_Ping(OCI_Connection *con)
Makes a round trip call to the server to confirm that the connection and the server are active...
OCI_EXPORT unsigned int OCI_API OCI_GetAffectedRows(OCI_Statement *stmt)
Return the number of rows affected by the SQL statement.
OCI_EXPORT unsigned int OCI_API OCI_LobRead(OCI_Lob *lob, void *buffer, unsigned int len)
[OBSOLETE] Read a portion of a lob into the given buffer
OCI_EXPORT unsigned short OCI_API OCI_GetUnsignedShort2(OCI_Resultset *rs, const otext *name)
Return the current unsigned short value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_ElemSetInterval(OCI_Elem *elem, OCI_Interval *value)
Assign an Interval handle to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetStatementCacheSize(OCI_Pool *pool)
Return the maximum number of statements to keep in the pool statement cache.
OCI_EXPORT boolean OCI_API OCI_BindDouble(OCI_Statement *stmt, const otext *name, double *data)
Bind a double variable.
OCI_EXPORT boolean OCI_API OCI_LobAppend2(OCI_Lob *lob, void *buffer, unsigned int *char_count, unsigned int *byte_count)
Append a buffer at the end of a LOB.
OCI_EXPORT OCI_Ref *OCI_API OCI_ObjectGetRef(OCI_Object *obj, const otext *attr)
Return the Ref value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_ObjectSetDouble(OCI_Object *obj, const otext *attr, double value)
Set an object attribute of type double.
OCI_EXPORT OCI_Lob *OCI_API OCI_GetLob2(OCI_Resultset *rs, const otext *name)
Return the current lob value of the column from its name in the resultset.
OCI_EXPORT int OCI_API OCI_ColumnGetScale(OCI_Column *col)
Return the scale of the column for numeric columns.
OCI_EXPORT boolean OCI_API OCI_SetDefaultLobPrefetchSize(OCI_Connection *con, unsigned int value)
Enable or disable prefetching for all LOBs fetched in the connection.
OCI_EXPORT boolean OCI_API OCI_CollDeleteElem(OCI_Coll *coll, unsigned int index)
Delete the element at the given position in the Nested Table Collection.
OCI_EXPORT boolean OCI_API OCI_TimestampFromText(OCI_Timestamp *tmsp, const otext *str, const otext *fmt)
Convert a string to a timestamp and store it in the given timestamp handle.
OCI_EXPORT int OCI_API OCI_DateCompare(OCI_Date *date, OCI_Date *date2)
Compares two date handles.
OCI_EXPORT OCI_Lob **OCI_API OCI_LobArrayCreate(OCI_Connection *con, unsigned int type, unsigned int nbelem)
Create an array of lob object.
struct OCI_XID OCI_XID
Global transaction identifier.
OCI_EXPORT boolean OCI_API OCI_MsgSetOriginalID(OCI_Msg *msg, const void *id, unsigned int len)
Set the original ID of the message in the last queue that generated this message. ...
OCI_EXPORT OCI_Interval *OCI_API OCI_GetInterval(OCI_Resultset *rs, unsigned int index)
Return the current interval value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_ObjectSetRef(OCI_Object *obj, const otext *attr, OCI_Ref *value)
Set an object attribute of type Ref.
OCI_EXPORT OCI_Bind *OCI_API OCI_GetBind(OCI_Statement *stmt, unsigned int index)
Return the bind handle at the given index in the internal array of bind handle.
OCI_EXPORT OCI_Lob *OCI_API OCI_ObjectGetLob(OCI_Object *obj, const otext *attr)
Return the lob value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_NumberAdd(OCI_Number *number, unsigned int type, void *value)
Add the value of a native C numeric type to the given number.
OCI_EXPORT boolean OCI_API OCI_BindIsNull(OCI_Bind *bnd)
Check if the current value of the binded variable is marked as NULL.
OCI_EXPORT boolean OCI_API OCI_MsgGetOriginalID(OCI_Msg *msg, void *id, unsigned int *len)
Return the original ID of the message in the last queue that generated this message.
OCI_EXPORT boolean OCI_API OCI_ObjectSetNumber(OCI_Object *obj, const otext *attr, OCI_Number *value)
Set an object attribute of type number.
OCI_EXPORT boolean OCI_API OCI_DirPathSetBufferSize(OCI_DirPath *dp, unsigned int size)
Set the size of the internal stream transfer buffer.
OCI_EXPORT boolean OCI_API OCI_Commit(OCI_Connection *con)
Commit current pending changes.
OCI_EXPORT boolean OCI_API OCI_NumberDivide(OCI_Number *number, unsigned int type, void *value)
Divide the given number with the value of a native C numeric.
OCI_EXPORT unsigned int OCI_API OCI_GetBatchErrorCount(OCI_Statement *stmt)
Returns the number of errors that occurred within the last DML array statement.
OCI_EXPORT OCI_Ref *OCI_API OCI_GetRef(OCI_Resultset *rs, unsigned int index)
Return the current Ref value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_StatementFree(OCI_Statement *stmt)
Free a statement and all resources associated to it (resultsets ...)
OCI_EXPORT const otext *OCI_API OCI_GetString(OCI_Resultset *rs, unsigned int index)
Return the current string value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_ElemSetBigInt(OCI_Elem *elem, big_int value)
Set a big int value to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_ErrorGetType(OCI_Error *err)
Retrieve the type of error from error handle.
OCI_EXPORT int OCI_API OCI_DateCheck(OCI_Date *date)
Check if the given date is valid.
OCI_EXPORT boolean OCI_API OCI_BindBigInt(OCI_Statement *stmt, const otext *name, big_int *data)
Bind a big integer variable.
OCI_EXPORT unsigned int OCI_API OCI_DirPathLoad(OCI_DirPath *dp)
Loads the data converted to direct path stream format.
OCI_EXPORT OCI_Date *OCI_API OCI_GetDate(OCI_Resultset *rs, unsigned int index)
Return the current date value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_Break(OCI_Connection *con)
Perform an immediate abort of any currently Oracle OCI call.
OCI_EXPORT boolean OCI_API OCI_BindSetDataSize(OCI_Bind *bnd, unsigned int size)
Set the actual size of the element held by the given bind handle.
OCI_EXPORT boolean OCI_API OCI_SetTAFHandler(OCI_Connection *con, POCI_TAF_HANDLER handler)
Set the Transparent Application Failover (TAF) user handler.
OCI_EXPORT boolean OCI_API OCI_DirPathFree(OCI_DirPath *dp)
Free an OCI_DirPath handle.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfIntervals(OCI_Statement *stmt, const otext *name, OCI_Interval **data, unsigned int type, unsigned int nbelem)
Bind an array of interval handles.
OCI_EXPORT unsigned int OCI_API OCI_FileRead(OCI_File *file, void *buffer, unsigned int len)
Read a portion of a file into the given buffer.
struct OCI_Interval OCI_Interval
Oracle internal interval representation.
OCI_EXPORT boolean OCI_API OCI_LobCopyFromFile(OCI_Lob *lob, OCI_File *file, big_uint offset_dst, big_uint offset_src, big_uint count)
Copy a portion of a source FILE into a destination LOB.
OCI_EXPORT const otext *OCI_API OCI_GetSqlIdentifier(OCI_Statement *stmt)
Returns the statement SQL_ID from the server.
OCI_EXPORT boolean OCI_API OCI_DateFree(OCI_Date *date)
Free a date object.
OCI_EXPORT const otext *OCI_API OCI_MsgGetExceptionQueue(OCI_Msg *msg)
Get the Exception queue name of the message.
struct OCI_Dequeue OCI_Dequeue
OCILIB encapsulation of A/Q dequeuing operations.
OCI_EXPORT OCI_Object *OCI_API OCI_GetObject2(OCI_Resultset *rs, const otext *name)
Return the current Object value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_GetAutoCommit(OCI_Connection *con)
Get current auto commit mode status.
OCI_EXPORT unsigned short OCI_API OCI_ElemGetUnsignedShort(OCI_Elem *elem)
Return the unsigned short value of the given collection element.
void(* POCI_ERROR)(OCI_Error *err)
Error procedure prototype.
struct OCI_Statement OCI_Statement
Oracle SQL or PL/SQL statement.
OCI_EXPORT OCI_Ref *OCI_API OCI_GetRef2(OCI_Resultset *rs, const otext *name)
Return the current Ref value of the column from its name in the resultset.
OCI_EXPORT big_uint OCI_API OCI_FileGetSize(OCI_File *file)
Return the size in bytes of a file.
void(* POCI_HA_HANDLER)(OCI_Connection *con, unsigned int source, unsigned int event, OCI_Timestamp *time)
HA (High Availability) events Notification User callback prototype.
OCI_EXPORT OCI_File *OCI_API OCI_GetFile2(OCI_Resultset *rs, const otext *name)
Return the current File value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_BindInterval(OCI_Statement *stmt, const otext *name, OCI_Interval *data)
Bind an interval variable.
OCI_EXPORT boolean OCI_API OCI_FileSetName(OCI_File *file, const otext *dir, const otext *name)
Set the directory and file name of FILE handle.
OCI_EXPORT int OCI_API OCI_ErrorGetOCICode(OCI_Error *err)
Retrieve Oracle Error code from error handle.
OCI_EXPORT const otext *OCI_API OCI_MsgGetCorrelation(OCI_Msg *msg)
Get the correlation identifier of the message.
struct OCI_Enqueue OCI_Enqueue
OCILIB encapsulation of A/Q enqueuing operations.
OCI_EXPORT int OCI_API OCI_DateAssign(OCI_Date *date, OCI_Date *date_src)
Assign the value of a date handle to another one.
struct OCI_Bind OCI_Bind
Internal bind representation.
OCI_EXPORT const void *OCI_API OCI_HandleGetDirPathCtx(OCI_DirPath *dp)
Return OCI DirectPath Context handle (OCIDirPathCtx *) of an OCILIB OCI_DirPath object.
OCI_EXPORT boolean OCI_API OCI_BindInt(OCI_Statement *stmt, const otext *name, int *data)
Bind an integer variable.
OCI_EXPORT boolean OCI_API OCI_ThreadKeyCreate(const otext *name, POCI_THREADKEYDEST destfunc)
Create a thread key object.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfTimestamps(OCI_Statement *stmt, const otext *name, OCI_Timestamp **data, unsigned int type, unsigned int nbelem)
Bind an array of timestamp handles.
OCI_EXPORT boolean OCI_API OCI_ObjectSetObject(OCI_Object *obj, const otext *attr, OCI_Object *value)
Set an object attribute of type Object.
OCI_EXPORT boolean OCI_API OCI_NumberToText(OCI_Number *number, const otext *fmt, int size, otext *str)
Convert a number value from the given number handle to a string.
OCI_EXPORT boolean OCI_API OCI_TimestampGetDateTime(OCI_Timestamp *tmsp, int *year, int *month, int *day, int *hour, int *min, int *sec, int *fsec)
Extract the date and time parts from a date handle.
OCI_EXPORT boolean OCI_API OCI_GetStruct(OCI_Resultset *rs, void *row_struct, void *row_struct_ind)
Return the row columns values into a single structure.
struct OCI_Subscription OCI_Subscription
OCILIB encapsulation of Oracle DCN notification.
OCI_EXPORT boolean OCI_API OCI_BindFile(OCI_Statement *stmt, const otext *name, OCI_File *data)
Bind a File variable.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfShorts(OCI_Statement *stmt, const otext *name, short *data, unsigned int nbelem)
Bind an array of shorts.
struct OCI_Pool OCI_Pool
Pool object (session or connection)
OCI_EXPORT boolean OCI_API OCI_BindArrayOfDoubles(OCI_Statement *stmt, const otext *name, double *data, unsigned int nbelem)
Bind an array of doubles.
OCI_EXPORT boolean OCI_API OCI_SetStructNumericType2(OCI_Resultset *rs, const otext *name, unsigned int type)
set the numeric data type of the given structure member (identified from column name in the resultset...
OCI_EXPORT boolean OCI_API OCI_HashFree(OCI_HashTable *table)
Destroy a hash table.
OCI_EXPORT OCI_Statement *OCI_API OCI_ResultsetGetStatement(OCI_Resultset *rs)
Return the statement handle associated with a resultset handle.
OCI_EXPORT short OCI_API OCI_ObjectGetShort(OCI_Object *obj, const otext *attr)
Return the short value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_ObjectSetColl(OCI_Object *obj, const otext *attr, OCI_Coll *value)
Set an object attribute of type Collection.
OCI_EXPORT int OCI_API OCI_TimestampCompare(OCI_Timestamp *tmsp, OCI_Timestamp *tmsp2)
Compares two timestamp handles.
OCI_EXPORT double OCI_API OCI_GetDouble2(OCI_Resultset *rs, const otext *name)
Return the current double value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_ElemSetBoolean(OCI_Elem *elem, boolean value)
Set a boolean value to a collection element.
OCI_EXPORT boolean OCI_API OCI_BindObject(OCI_Statement *stmt, const otext *name, OCI_Object *data)
Bind an object (named type) variable.
OCI_EXPORT const otext *OCI_API OCI_SubscriptionGetName(OCI_Subscription *sub)
Return the name of the given registered subscription.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetOpenedCount(OCI_Pool *pool)
Return the current number of opened connections/sessions.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetSubType(OCI_Column *col)
Return the OCILIB object subtype of a column.
OCI_EXPORT unsigned int OCI_API OCI_BindGetDataSize(OCI_Bind *bnd)
Return the actual size of the element held by the given bind handle.
OCI_EXPORT boolean OCI_API OCI_FileIsOpen(OCI_File *file)
Check if the specified file is opened within the file handle.
OCI_EXPORT int OCI_API OCI_GetInt2(OCI_Resultset *rs, const otext *name)
Return the current integer value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_PoolSetNoWait(OCI_Pool *pool, boolean value)
Set the waiting mode used when no more connections/sessions are available from the pool...
OCI_EXPORT boolean OCI_API OCI_DateGetDateTime(OCI_Date *date, int *year, int *month, int *day, int *hour, int *min, int *sec)
Extract the date and time parts from a date handle.
OCI_EXPORT OCI_Long *OCI_API OCI_GetLong(OCI_Resultset *rs, unsigned int index)
Return the current Long value of the column at the given index in the resultset.
OCI_EXPORT const otext *OCI_API OCI_EventGetObject(OCI_Event *event)
Return the name of the object that generated the event.
OCI_EXPORT big_uint OCI_API OCI_ObjectGetUnsignedBigInt(OCI_Object *obj, const otext *attr)
Return the unsigned big integer value of the given object attribute.
OCI_EXPORT big_uint OCI_API OCI_GetUnsignedBigInt2(OCI_Resultset *rs, const otext *name)
Return the current unsigned big integer value of the column from its name in the resultset.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_GetInstanceStartTime(OCI_Connection *con)
Return the date and time (Timestamp) server instance start of the connected database/service name...
OCI_EXPORT OCI_Date *OCI_API OCI_GetDate2(OCI_Resultset *rs, const otext *name)
Return the current date value of the column from its name in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetIncrement(OCI_Pool *pool)
Return the increment for connections/sessions to be opened to the database when the pool is not full...
OCI_EXPORT boolean OCI_API OCI_DequeueSetConsumer(OCI_Dequeue *dequeue, const otext *consumer)
Set the current consumer name to retrieve message for.
OCI_EXPORT const otext *OCI_API OCI_GetSessionTag(OCI_Connection *con)
Return the tag associated the given connection.
OCI_EXPORT unsigned int OCI_API OCI_ElemGetRawSize(OCI_Elem *elem)
Return the raw attribute value size of the given element handle.
OCI_EXPORT boolean OCI_API OCI_QueueTableAlter(OCI_Connection *con, const otext *queue_table, const otext *comment, unsigned int primary_instance, unsigned int secondary_instance)
Alter the given queue table.
OCI_EXPORT boolean OCI_API OCI_MsgReset(OCI_Msg *msg)
Reset all attributes of a message object.
struct OCI_Timestamp OCI_Timestamp
Oracle internal timestamp representation.
OCI_EXPORT boolean OCI_API OCI_AgentSetName(OCI_Agent *agent, const otext *name)
Set the given AQ agent name.
OCI_EXPORT boolean OCI_API OCI_QueueTablePurge(OCI_Connection *con, const otext *queue_table, const otext *purge_condition, boolean block, unsigned int delivery_mode)
Purge messages from the given queue table.
struct OCI_HashEntry OCI_HashEntry
Hash table entry.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetMax(OCI_Pool *pool)
Return the maximum number of connections/sessions that can be opened to the database.
OCI_EXPORT boolean OCI_API OCI_LobIsEqual(OCI_Lob *lob, OCI_Lob *lob2)
Compare two lob handles for equality.
OCI_EXPORT boolean OCI_API OCI_LobAssign(OCI_Lob *lob, OCI_Lob *lob_src)
Assign a lob to another one.
OCI_EXPORT big_uint OCI_API OCI_LobErase(OCI_Lob *lob, big_uint offset, big_uint len)
Erase a portion of the lob at a given position.
OCI_EXPORT const otext *OCI_API OCI_GetString2(OCI_Resultset *rs, const otext *name)
Return the current string value of the column from its name in the resultset.
OCI_EXPORT const void *OCI_API OCI_HandleGetColl(OCI_Coll *coll)
Return OCI Collection Handle (OCIColl *) of an OCILIB OCI_Coll object.
OCI_EXPORT OCI_TypeInfo *OCI_API OCI_CollGetTypeInfo(OCI_Coll *coll)
Return the type info object associated to the collection.
OCI_EXPORT boolean OCI_API OCI_SetTimeout(OCI_Connection *con, unsigned int type, unsigned int value)
Set a given timeout for OCI calls that require server round-trips to the given database.
OCI_EXPORT const void *OCI_API OCI_HandleGetSession(OCI_Connection *con)
Return the OCI Session Handle (OCISession *) of an OCILIB OCI_Connection object.
void(* POCI_THREAD)(OCI_Thread *thread, void *arg)
Thread procedure prototype.
OCI_EXPORT const void *OCI_API OCI_HandleGetDirPathStream(OCI_DirPath *dp)
Return OCI DirectPath Stream handle (OCIDirPathStream *) of an OCILIB OCI_DirPath object...
OCI_EXPORT unsigned int OCI_API OCI_LobGetChunkSize(OCI_Lob *lob)
Returns the chunk size of a LOB.
OCI_EXPORT boolean OCI_API OCI_RefToText(OCI_Ref *ref, unsigned int size, otext *str)
Converts a Ref handle value to a hexadecimal string.
OCI_EXPORT boolean OCI_API OCI_ThreadJoin(OCI_Thread *thread)
Join the given thread.
OCI_EXPORT unsigned int OCI_API OCI_GetCharset(void)
Return the OCILIB charset type.
OCI_EXPORT float OCI_API OCI_ElemGetFloat(OCI_Elem *elem)
Return the float value of the given collection element.
OCI_EXPORT unsigned int OCI_API OCI_GetServerRevisionVersion(OCI_Connection *con)
Return the revision version number of the connected database server.
OCI_EXPORT boolean OCI_API OCI_ObjectAssign(OCI_Object *obj, OCI_Object *obj_src)
Assign an object to another one.
OCI_EXPORT boolean OCI_API OCI_NumberSetContent(OCI_Number *number, unsigned char *content)
Assign the number value content.
OCI_EXPORT boolean OCI_API OCI_BindRaw(OCI_Statement *stmt, const otext *name, void *data, unsigned int len)
Bind a raw buffer.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfLobs(OCI_Statement *stmt, const otext *name, OCI_Lob **data, unsigned int type, unsigned int nbelem)
Bind an array of Lob handles.
OCI_EXPORT boolean OCI_API OCI_ElemGetBoolean(OCI_Elem *elem)
Return the boolean value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_DirPathSetCacheSize(OCI_DirPath *dp, unsigned int size)
Set number of elements in the date cache.
OCI_EXPORT OCI_Date *OCI_API OCI_ElemGetDate(OCI_Elem *elem)
Return the Date value of the given collection element.
OCI_EXPORT unsigned int OCI_API OCI_GetRowCount(OCI_Resultset *rs)
Retrieve the number of rows fetched so far.
OCI_EXPORT unsigned int OCI_API OCI_LobWrite(OCI_Lob *lob, void *buffer, unsigned int len)
[OBSOLETE] Write a buffer into a LOB
OCI_EXPORT boolean OCI_API OCI_BindSetDataSizeAtPos(OCI_Bind *bnd, unsigned int position, unsigned int size)
Set the size of the element at the given position in the bind input array.
OCI_EXPORT unsigned int OCI_API OCI_BindArrayGetSize(OCI_Statement *stmt)
Return the current input array size for bulk operations.
OCI_EXPORT unsigned int OCI_API OCI_EventGetType(OCI_Event *event)
Return the type of event reported by a notification.
boolean OCI_API OCI_BindSetCharsetForm(OCI_Bind *bnd, unsigned int csfrm)
Set the charset form of the given character based bind variable.
OCI_EXPORT boolean OCI_API OCI_DatabaseShutdown(const otext *db, const otext *user, const otext *pwd, unsigned int sess_mode, unsigned int shut_mode, unsigned int shut_flag)
Shutdown a database instance.
OCI_EXPORT boolean OCI_API OCI_DateGetTime(OCI_Date *date, int *hour, int *min, int *sec)
Extract the time part from a date handle.
OCI_EXPORT boolean OCI_API OCI_SetBindAllocation(OCI_Statement *stmt, unsigned int mode)
Set the current bind allocation mode that will be used for subsequent binding calls.
OCI_EXPORT const otext *OCI_API OCI_GetPassword(OCI_Connection *con)
Return the current logged user password.
OCI_EXPORT boolean OCI_API OCI_TimestampGetTime(OCI_Timestamp *tmsp, int *hour, int *min, int *sec, int *fsec)
Extract the time portion from a timestamp handle.
OCI_EXPORT boolean OCI_API OCI_NumberFree(OCI_Number *number)
Free a number object.
OCI_EXPORT const void *OCI_API OCI_HandleGetDate(OCI_Date *date)
Return the OCI Date Handle (OCIDate *) of an OCILIB OCI_Date object.
OCI_EXPORT boolean OCI_API OCI_LobWrite2(OCI_Lob *lob, void *buffer, unsigned int *char_count, unsigned int *byte_count)
Write a buffer into a LOB.
OCI_EXPORT unsigned int OCI_API OCI_GetUnsignedInt2(OCI_Resultset *rs, const otext *name)
Return the current unsigned integer value of the column from its name in the resultset.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_ObjectGetTimestamp(OCI_Object *obj, const otext *attr)
Return the timestamp value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_BindSetDirection(OCI_Bind *bnd, unsigned int direction)
Set the direction mode of a bind handle.
OCI_EXPORT boolean OCI_API OCI_EnqueueGetRelativeMsgID(OCI_Enqueue *enqueue, void *id, unsigned int *len)
Get the current associated message identifier used for enqueuing messages using a sequence deviation...
struct OCI_Msg OCI_Msg
OCILIB encapsulation of A/Q message.
OCI_EXPORT boolean OCI_API OCI_IsRebindingAllowed(OCI_Statement *stmt)
Indicate if rebinding is allowed on the given statement.
OCI_EXPORT boolean OCI_API OCI_TimestampGetTimeZoneName(OCI_Timestamp *tmsp, int size, otext *str)
Return the time zone name of a timestamp handle.
OCI_EXPORT unsigned int OCI_API OCI_TransactionGetMode(OCI_Transaction *trans)
Return global transaction mode.
OCI_EXPORT OCI_Statement *OCI_API OCI_BindGetStatement(OCI_Bind *bnd)
Return the statement handle associated with a bind handle.
OCI_EXPORT boolean OCI_API OCI_IntervalGetDaySecond(OCI_Interval *itv, int *day, int *hour, int *min, int *sec, int *fsec)
Return the day / time portion of an interval handle.
OCI_EXPORT boolean OCI_API OCI_ObjectGetStruct(OCI_Object *obj, void **pp_struct, void **pp_ind)
Retrieve the underlying C (OTT/OCI style) structure of an OCI_Object handle.
OCI_EXPORT boolean OCI_API OCI_ElemSetRef(OCI_Elem *elem, OCI_Ref *value)
Assign a Ref handle to a collection element.
OCI_EXPORT OCI_Object *OCI_API OCI_ObjectGetObject(OCI_Object *obj, const otext *attr)
Return the object value of the given object attribute.
OCI_EXPORT unsigned int OCI_API OCI_EventGetOperation(OCI_Event *event)
Return the type of operation reported by a notification.
OCI_EXPORT boolean OCI_API OCI_ThreadKeySetValue(const otext *name, void *value)
Set a thread key value.
OCI_EXPORT short OCI_API OCI_GetShort2(OCI_Resultset *rs, const otext *name)
Return the current short value of the column from its name in the resultset.
OCI_EXPORT OCI_Iter *OCI_API OCI_IterCreate(OCI_Coll *coll)
Create an iterator handle to iterate through a collection.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfUnsignedBigInts(OCI_Statement *stmt, const otext *name, big_uint *data, unsigned int nbelem)
Bind an array of unsigned big integers.
OCI_EXPORT boolean OCI_API OCI_TimestampIntervalSub(OCI_Timestamp *tmsp, OCI_Interval *itv)
Subtract an interval value from a timestamp value of a timestamp handle.
OCI_EXPORT boolean OCI_API OCI_MutexFree(OCI_Mutex *mutex)
Destroy a mutex object.
OCI_EXPORT boolean OCI_API OCI_LobIsRemote(OCI_Lob *lob)
Indicates if the given lob belongs to a local or remote database table.
OCI_EXPORT boolean OCI_API OCI_TimestampFree(OCI_Timestamp *tmsp)
Free an OCI_Timestamp handle.
OCI_EXPORT unsigned int OCI_API OCI_BindGetSubtype(OCI_Bind *bnd)
Return the OCILIB object subtype of the given bind.
OCI_EXPORT boolean OCI_API OCI_SetUserData(OCI_Connection *con, void *data)
Associate a pointer to user data to the given connection.
OCI_EXPORT OCI_Date *OCI_API OCI_DateCreate(OCI_Connection *con)
Create a local date object.
OCI_EXPORT OCI_Ref *OCI_API OCI_RefCreate(OCI_Connection *con, OCI_TypeInfo *typinf)
Create a local Ref instance.
OCI_EXPORT OCI_Interval *OCI_API OCI_IntervalCreate(OCI_Connection *con, unsigned int type)
Create a local interval object.
OCI_EXPORT OCI_Connection *OCI_API OCI_LobGetConnection(OCI_Lob *lob)
Retrieve connection handle from the lob handle.
OCI_EXPORT boolean OCI_API OCI_EnqueueSetSequenceDeviation(OCI_Enqueue *enqueue, unsigned int sequence)
Set the enqueuing sequence of messages to put in the queue.
OCI_EXPORT const otext *OCI_API OCI_GetDBName(OCI_Connection *con)
Return the Oracle server database name of the connected database/service name.
OCI_EXPORT boolean OCI_API OCI_ElemIsNull(OCI_Elem *elem)
Check if the collection element value is null.
OCI_EXPORT boolean OCI_API OCI_RegisterBigInt(OCI_Statement *stmt, const otext *name)
Register a big integer output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfFloats(OCI_Statement *stmt, const otext *name, float *data, unsigned int nbelem)
Bind an array of floats.
OCI_EXPORT big_uint OCI_API OCI_FileGetOffset(OCI_File *file)
Return the current position in the file.
OCI_EXPORT boolean OCI_API OCI_SetLongMaxSize(OCI_Statement *stmt, unsigned int size)
Set the LONG data type piece buffer size.
OCI_EXPORT OCI_TypeInfo *OCI_API OCI_RefGetTypeInfo(OCI_Ref *ref)
Return the type info object associated to the Ref.
OCI_EXPORT boolean OCI_API OCI_ElemSetLob(OCI_Elem *elem, OCI_Lob *value)
Assign a Lob handle to a collection element.
OCI_EXPORT OCI_File *OCI_API OCI_FileCreate(OCI_Connection *con, unsigned int type)
Create a file object instance.
union OCI_Variant OCI_Variant
Internal Variant type based on union C type.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfUnsignedInts(OCI_Statement *stmt, const otext *name, unsigned int *data, unsigned int nbelem)
Bind an array of unsigned integers.
OCI_EXPORT OCI_Transaction *OCI_API OCI_TransactionCreate(OCI_Connection *con, unsigned int timeout, unsigned int mode, OCI_XID *pxid)
Create a new global transaction or a serializable/read-only local transaction.
OCI_EXPORT OCI_Coll *OCI_API OCI_GetColl(OCI_Resultset *rs, unsigned int index)
Return the current Collection value of the column at the given index in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_ObjectGetUnsignedInt(OCI_Object *obj, const otext *attr)
Return the unsigned integer value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_ElemSetUnsignedShort(OCI_Elem *elem, unsigned short value)
Set a unsigned short value to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetCollationID(OCI_Column *col)
Return the column collation ID.
OCI_EXPORT boolean OCI_API OCI_SetPassword(OCI_Connection *con, const otext *password)
Change the password of the logged user.
struct OCI_Ref OCI_Ref
Oracle REF type representation.
OCI_EXPORT int OCI_API OCI_TimestampCheck(OCI_Timestamp *tmsp)
Check if the given timestamp is valid.
OCI_EXPORT big_uint OCI_API OCI_GetUnsignedBigInt(OCI_Resultset *rs, unsigned int index)
Return the current unsigned big integer value of the column at the given index in the resultset...
OCI_EXPORT OCI_HashEntry *OCI_API OCI_HashGetEntry(OCI_HashTable *table, unsigned int index)
Return the entry slot of the hash table internal list at the given position.
OCI_EXPORT boolean OCI_API OCI_TransactionForget(OCI_Transaction *trans)
Cancel the prepared global transaction validation.
OCI_EXPORT unsigned int OCI_API OCI_GetRaw2(OCI_Resultset *rs, const otext *name, void *buffer, unsigned int len)
Copy the current raw value of the column from its name into the specified buffer. ...
OCI_EXPORT boolean OCI_API OCI_IntervalToText(OCI_Interval *itv, int leading_prec, int fraction_prec, int size, otext *str)
Convert an interval value from the given interval handle to a string.
OCI_EXPORT boolean OCI_API OCI_DateFromCTime(OCI_Date *date, struct tm *ptm, time_t t)
Affect ISO C time data types values to an OCI_Date handle.
OCI_EXPORT boolean OCI_API OCI_EnableWarnings(boolean value)
Enable or disable Oracle warning notifications.
OCI_EXPORT const void *OCI_API OCI_HandleGetTimestamp(OCI_Timestamp *tmsp)
Return the OCI Date time Handle (OCIDatetime *) of an OCILIB OCI_Timestamp object.
OCI_EXPORT boolean OCI_API OCI_RegisterInt(OCI_Statement *stmt, const otext *name)
Register an integer output bind placeholder.
OCI_EXPORT OCI_Resultset *OCI_API OCI_GetResultset(OCI_Statement *stmt)
Retrieve the resultset handle from an executed statement.
OCI_EXPORT unsigned int OCI_API OCI_GetBindIndex(OCI_Statement *stmt, const otext *name)
Return the index of the bind from its name belonging to the given statement.
OCI_EXPORT boolean OCI_API OCI_TransactionFree(OCI_Transaction *trans)
Free current transaction.
OCI_EXPORT boolean OCI_API OCI_ObjectSetUnsignedBigInt(OCI_Object *obj, const otext *attr, big_uint value)
Set an object attribute of type unsigned big int.
OCI_EXPORT void *OCI_API OCI_GetUserData(OCI_Connection *con)
Return the pointer to user data previously associated with the connection.
OCI_EXPORT unsigned int OCI_API OCI_DequeueGetMode(OCI_Dequeue *dequeue)
Get the dequeuing/locking behavior.
OCI_EXPORT unsigned short OCI_API OCI_GetUnsignedShort(OCI_Resultset *rs, unsigned int index)
Return the current unsigned short value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_FetchFirst(OCI_Resultset *rs)
Fetch the first row of the resultset.
OCI_EXPORT boolean OCI_API OCI_DateSetTime(OCI_Date *date, int hour, int min, int sec)
Set the time portion if the given date handle.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_GetTimestamp2(OCI_Resultset *rs, const otext *name)
Return the current timestamp value of the column from its name in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_SubscriptionGetPort(OCI_Subscription *sub)
Return the port used by the notification.
OCI_EXPORT unsigned int OCI_API OCI_RefGetHexSize(OCI_Ref *ref)
Returns the size of the hex representation of the given Ref handle.
OCI_EXPORT const otext *OCI_API OCI_AgentGetAddress(OCI_Agent *agent)
Get the given AQ agent address.
OCI_EXPORT unsigned int OCI_API OCI_GetOCICompileVersion(void)
Return the version of OCI used for compilation.
OCI_EXPORT boolean OCI_API OCI_NumberSub(OCI_Number *number, unsigned int type, void *value)
Subtract the value of a native C numeric type to the given number.
OCI_EXPORT boolean OCI_API OCI_DatabaseStartup(const otext *db, const otext *user, const otext *pwd, unsigned int sess_mode, unsigned int start_mode, unsigned int start_flag, const otext *spfile)
Start a database instance.
OCI_EXPORT float OCI_API OCI_ObjectGetFloat(OCI_Object *obj, const otext *attr)
Return the float value of the given object attribute.
OCI_EXPORT int OCI_API OCI_ColumnGetLeadingPrecision(OCI_Column *col)
Return the leading precision of the column for interval columns.
OCI_EXPORT unsigned int OCI_API OCI_GetServerMinorVersion(OCI_Connection *con)
Return the minor version number of the connected database server.
OCI_EXPORT boolean OCI_API OCI_DirPathReset(OCI_DirPath *dp)
Reset internal arrays and streams to prepare another load.
OCI_EXPORT OCI_Interval *OCI_API OCI_ElemGetInterval(OCI_Elem *elem)
Return the Interval value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_MsgSetObject(OCI_Msg *msg, OCI_Object *obj)
Set the object payload of the given message.
OCI_EXPORT unsigned int OCI_API OCI_CollGetMax(OCI_Coll *coll)
Returns the maximum number of elements of the given collection.
OCI_EXPORT const otext *OCI_API OCI_DequeueGetCorrelation(OCI_Dequeue *dequeue)
Get the correlation identifier of the message to be dequeued.
OCI_EXPORT int OCI_API OCI_NumberCompare(OCI_Number *number1, OCI_Number *number2)
Compares two number handles.
OCI_EXPORT unsigned int OCI_API OCI_ElemGetRaw(OCI_Elem *elem, void *value, unsigned int len)
Read the RAW value of the collection element into the given buffer.
OCI_EXPORT const void *OCI_API OCI_HandleGetObject(OCI_Object *obj)
Return OCI Object Handle (void *) of an OCILIB OCI_Object object.
OCI_EXPORT unsigned int OCI_API OCI_GetDataSize2(OCI_Resultset *rs, const otext *name)
Return the size of the value of the column from its name in the resultset.
OCI_EXPORT OCI_Statement *OCI_API OCI_GetStatement2(OCI_Resultset *rs, const otext *name)
Return the current cursor value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_FileFree(OCI_File *file)
Free a local File object.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetPropertyFlags(OCI_Column *col)
Return the column property flags.
OCI_EXPORT unsigned int OCI_API OCI_HashGetSize(OCI_HashTable *table)
Return the size of the hash table.
OCI_EXPORT boolean OCI_API OCI_LobOpen(OCI_Lob *lob, unsigned int mode)
Open explicitly a Lob.
struct OCI_Date OCI_Date
Oracle internal date representation.
OCI_EXPORT big_int OCI_API OCI_GetBigInt(OCI_Resultset *rs, unsigned int index)
Return the current big integer value of the column at the given index in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_DequeueGetNavigation(OCI_Dequeue *dequeue)
Return the navigation position of messages to retrieve from the queue.
OCI_EXPORT OCI_Number *OCI_API OCI_ElemGetNumber(OCI_Elem *elem)
Return the number value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_PoolGetNoWait(OCI_Pool *pool)
Get the waiting mode used when no more connections/sessions are available from the pool...
OCI_EXPORT unsigned int OCI_API OCI_DirPathConvert(OCI_DirPath *dp)
Convert provided user data to the direct path stream format.
OCI_EXPORT boolean OCI_API OCI_DateSetDate(OCI_Date *date, int year, int month, int day)
Set the date portion if the given date handle.
OCI_EXPORT int OCI_API OCI_DateDaysBetween(OCI_Date *date, OCI_Date *date2)
Return the number of days betWeen two dates.
OCI_EXPORT unsigned int OCI_API OCI_GetVersionConnection(OCI_Connection *con)
Return the highest Oracle version is supported by the connection.
OCI_EXPORT unsigned int OCI_API OCI_BindGetDataSizeAtPos(OCI_Bind *bnd, unsigned int position)
Return the actual size of the element at the given position in the bind input array.
OCI_EXPORT boolean OCI_API OCI_IsTAFCapable(OCI_Connection *con)
Verify if the given connection support TAF events.
OCI_EXPORT boolean OCI_API OCI_HashAddInt(OCI_HashTable *table, const otext *key, int value)
Adds a pair string key / integer value to the hash table.
OCI_EXPORT const void *OCI_API OCI_HandleGetEnvironment(void)
Return the OCI Environment Handle (OCIEnv *) of OCILIB library.
OCI_EXPORT int OCI_API OCI_MsgGetExpiration(OCI_Msg *msg)
Return the duration that the message is available for dequeuing.
OCI_EXPORT const void *OCI_API OCI_HandleGetContext(OCI_Connection *con)
Return the OCI Context Handle (OCISvcCtx *) of an OCILIB OCI_Connection object.
OCI_EXPORT boolean OCI_API OCI_BindDate(OCI_Statement *stmt, const otext *name, OCI_Date *data)
Bind a date variable.
OCI_EXPORT boolean OCI_API OCI_CollFree(OCI_Coll *coll)
Free a local collection.
OCI_EXPORT boolean OCI_API OCI_DateSysDate(OCI_Date *date)
Return the current system date/time into the date handle.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfRaws(OCI_Statement *stmt, const otext *name, void *data, unsigned int len, unsigned int nbelem)
Bind an array of raw buffers.
OCI_EXPORT OCI_Object *OCI_API OCI_RefGetObject(OCI_Ref *ref)
Returns the object pointed by the Ref handle.
OCI_EXPORT OCI_Coll *OCI_API OCI_ElemGetColl(OCI_Elem *elem)
Return the collection value of the given collection element.
struct OCI_Transaction OCI_Transaction
Oracle Transaction.
OCI_EXPORT unsigned int OCI_API OCI_CollGetCount(OCI_Coll *coll)
Returns the current number of elements of the given collection.
OCI_EXPORT OCI_Elem *OCI_API OCI_CollGetElem(OCI_Coll *coll, unsigned int index)
Return the element at the given position in the collection.
OCI_EXPORT unsigned char *OCI_API OCI_NumberGetContent(OCI_Number *number)
Return the number value content.
OCI_EXPORT boolean OCI_API OCI_ElemSetUnsignedInt(OCI_Elem *elem, unsigned int value)
Set a unsigned int value to a collection element.
OCI_EXPORT unsigned short OCI_API OCI_ObjectGetUnsignedShort(OCI_Object *obj, const otext *attr)
Return the unsigned short value of the given object attribute.
OCI_EXPORT void *OCI_API OCI_HashGetPointer(OCI_HashTable *table, const otext *key)
Return a pointer associated with the given key.
OCI_EXPORT const otext *OCI_API OCI_GetInstanceName(OCI_Connection *con)
Return the Oracle server Instance name of the connected database/service name.
OCI_EXPORT unsigned int OCI_API OCI_GetFetchMode(OCI_Statement *stmt)
Return the fetch mode of a SQL statement.
OCI_EXPORT boolean OCI_API OCI_SubscriptionAddStatement(OCI_Subscription *sub, OCI_Statement *stmt)
Add a statement to the notification to monitor.
OCI_EXPORT boolean OCI_API OCI_LobTruncate(OCI_Lob *lob, big_uint size)
Truncate the given lob to a shorter length.
OCI_EXPORT void *OCI_API OCI_ThreadKeyGetValue(const otext *name)
Get a thread key value.
OCI_EXPORT boolean OCI_API OCI_LobClose(OCI_Lob *lob)
Close explicitly a Lob.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfDates(OCI_Statement *stmt, const otext *name, OCI_Date **data, unsigned int nbelem)
Bind an array of dates.
OCI_EXPORT OCI_Interval *OCI_API OCI_GetInterval2(OCI_Resultset *rs, const otext *name)
Return the current interval value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_DateArrayFree(OCI_Date **dates)
Free an array of date objects.
OCI_EXPORT boolean OCI_API OCI_CollSetElem(OCI_Coll *coll, unsigned int index, OCI_Elem *elem)
Assign the given element value to the element at the given position in the collection.
OCI_EXPORT boolean OCI_API OCI_DirPathAbort(OCI_DirPath *dp)
Terminate a direct path operation without committing changes.
OCI_EXPORT boolean OCI_API OCI_CollAppend(OCI_Coll *coll, OCI_Elem *elem)
Append the given element at the end of the collection.
OCI_EXPORT unsigned int OCI_API OCI_GetSessionMode(OCI_Connection *con)
Return the current session mode.
OCI_EXPORT boolean OCI_API OCI_ElemSetUnsignedBigInt(OCI_Elem *elem, big_uint value)
Set a unsigned big_int value to a collection element.
OCI_EXPORT boolean OCI_API OCI_BindLob(OCI_Statement *stmt, const otext *name, OCI_Lob *data)
Bind a Lob variable.
OCI_EXPORT boolean OCI_API OCI_RegisterDouble(OCI_Statement *stmt, const otext *name)
Register a double output bind placeholder.
OCI_EXPORT unsigned int OCI_API OCI_GetColumnCount(OCI_Resultset *rs)
Return the number of columns in the resultset.
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetErrorColumn(OCI_DirPath *dp)
Return the index of a column which caused an error during data conversion.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetCharsetForm(OCI_Column *col)
Return the charset form of the given column.
void(* POCI_NOTIFY)(OCI_Event *event)
Database Change Notification User callback prototype.
OCI_EXPORT boolean OCI_API OCI_AllowRebinding(OCI_Statement *stmt, boolean value)
Allow different host variables to be binded using the same bind name or position between executions o...
OCI_EXPORT boolean OCI_API OCI_Describe(OCI_Statement *stmt, const otext *sql)
Describe the select list of a SQL select statement.
OCI_EXPORT const otext *OCI_API OCI_BindGetName(OCI_Bind *bnd)
Return the name of the given bind.
OCI_EXPORT boolean OCI_API OCI_ServerEnableOutput(OCI_Connection *con, unsigned int bufsize, unsigned int arrsize, unsigned int lnsize)
Enable the server output.
OCI_EXPORT unsigned int OCI_API OCI_LobAppend(OCI_Lob *lob, void *buffer, unsigned int len)
Append a buffer at the end of a LOB.
OCI_EXPORT unsigned int OCI_API OCI_GetMaxCursors(OCI_Connection *con)
Return the maximum number of SQL statements that can be opened in one session.
OCI_EXPORT boolean OCI_API OCI_LobCopy(OCI_Lob *lob, OCI_Lob *lob_src, big_uint offset_dst, big_uint offset_src, big_uint count)
Copy a portion of a source LOB into a destination LOB.
OCI_EXPORT boolean OCI_API OCI_MsgSetSender(OCI_Msg *msg, OCI_Agent *sender)
Set the original sender of a message.
OCI_EXPORT const otext *OCI_API OCI_GetSQLVerb(OCI_Statement *stmt)
Return the verb of the SQL command held by the statement handle.
OCI_EXPORT const otext *OCI_API OCI_ErrorGetString(OCI_Error *err)
Retrieve error message from error handle.
struct OCI_Resultset OCI_Resultset
Collection of output columns from a select statement.
OCI_EXPORT const void *OCI_API OCI_HandleGetError(OCI_Connection *con)
Return the OCI Error Handle (OCIError *) of an OCILIB OCI_Connection object.
OCI_EXPORT const otext *OCI_API OCI_GetDomainName(OCI_Connection *con)
Return the Oracle server domain name of the connected database/service name.
OCI_EXPORT boolean OCI_API OCI_ObjectIsNull(OCI_Object *obj, const otext *attr)
Check if an object attribute is null.
OCI_EXPORT int OCI_API OCI_DequeueGetWaitTime(OCI_Dequeue *dequeue)
Return the time that OCIDequeueGet() waits for messages if no messages are currently available...
OCI_EXPORT boolean OCI_API OCI_Execute(OCI_Statement *stmt)
Execute a prepared SQL statement or PL/SQL block.
OCI_EXPORT boolean OCI_API OCI_ObjectFree(OCI_Object *obj)
Free a local object.
OCI_EXPORT OCI_Number **OCI_API OCI_NumberArrayCreate(OCI_Connection *con, unsigned int nbelem)
Create an array of number object.
OCI_EXPORT boolean OCI_API OCI_ElemSetFile(OCI_Elem *elem, OCI_File *value)
Assign a File handle to a collection element.
OCI_EXPORT OCI_Error *OCI_API OCI_GetLastError(void)
Retrieve the last error or warning occurred within the last OCILIB call.
OCI_EXPORT boolean OCI_API OCI_TransactionPrepare(OCI_Transaction *trans)
Prepare a global transaction validation.
OCI_EXPORT const otext *OCI_API OCI_FileGetDirectory(OCI_File *file)
Return the directory of the given file.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfInts(OCI_Statement *stmt, const otext *name, int *data, unsigned int nbelem)
Bind an array of integers.
OCI_EXPORT OCI_Date *OCI_API OCI_MsgGetEnqueueTime(OCI_Msg *msg)
return the time the message was enqueued
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetAffectedRows(OCI_DirPath *dp)
return the number of rows successfully processed during in the last conversion or loading call ...
OCI_EXPORT boolean OCI_API OCI_LobArrayFree(OCI_Lob **lobs)
Free an array of lob objects.
OCI_EXPORT boolean OCI_API OCI_BindBoolean(OCI_Statement *stmt, const otext *name, boolean *data)
Bind a boolean variable (PL/SQL ONLY)
OCI_EXPORT OCI_Interval **OCI_API OCI_IntervalArrayCreate(OCI_Connection *con, unsigned int type, unsigned int nbelem)
Create an array of Interval object.
OCI_EXPORT boolean OCI_API OCI_SetErrorHandler(POCI_ERROR handler)
Set the global error user handler.
OCI_EXPORT int OCI_API OCI_GetInt(OCI_Resultset *rs, unsigned int index)
Return the current integer value of the column at the given index in the resultset.
OCI_EXPORT OCI_File **OCI_API OCI_FileArrayCreate(OCI_Connection *con, unsigned int type, unsigned int nbelem)
Create an array of file object.
OCI_EXPORT unsigned int OCI_API OCI_GetCurrentRow(OCI_Resultset *rs)
Retrieve the current row number.
OCI_EXPORT OCI_Connection *OCI_API OCI_SubscriptionGetConnection(OCI_Subscription *sub)
Return the connection handle associated with a subscription handle.
OCI_EXPORT boolean OCI_API OCI_ObjectSetUnsignedInt(OCI_Object *obj, const otext *attr, unsigned int value)
Set an object attribute of type unsigned int.
OCI_EXPORT float OCI_API OCI_GetFloat2(OCI_Resultset *rs, const otext *name)
Return the current float value of the column from its name in the resultset.
OCI_EXPORT big_int OCI_API OCI_GetBigInt2(OCI_Resultset *rs, const otext *name)
Return the current big integer value of the column from its name in the resultset.
struct OCI_DirPath OCI_DirPath
OCILIB encapsulation of OCI Direct Path handle.
OCI_EXPORT const void *OCI_API OCI_HandleGetSubscription(OCI_Subscription *sub)
Return OCI Subscription handle (OCISubscription *) of an OCILIB OCI_Subscription object.
OCI_EXPORT boolean OCI_API OCI_DirPathSetCurrentRows(OCI_DirPath *dp, unsigned int nb_rows)
Set the current number of rows to convert and load.
OCI_EXPORT boolean OCI_API OCI_MsgGetRaw(OCI_Msg *msg, void *raw, unsigned int *size)
Get the RAW payload of the given message.
OCI_EXPORT boolean OCI_API OCI_MutexRelease(OCI_Mutex *mutex)
Release a mutex lock.
OCI_EXPORT boolean OCI_API OCI_TimestampConstruct(OCI_Timestamp *tmsp, int year, int month, int day, int hour, int min, int sec, int fsec, const otext *time_zone)
Set a timestamp handle value.
OCI_EXPORT boolean OCI_API OCI_TimestampSubtract(OCI_Timestamp *tmsp, OCI_Timestamp *tmsp2, OCI_Interval *itv)
Store the difference of two timestamp handles into an interval handle.
OCI_EXPORT int OCI_API OCI_MsgGetPriority(OCI_Msg *msg)
Return the priority of the message.
OCI_EXPORT const void *OCI_API OCI_HandleGetLob(OCI_Lob *lob)
Return the OCI LobLocator Handle (OCILobLocator *) of an OCILIB OCI_Lob object.
OCI_EXPORT boolean OCI_API OCI_DateZoneToZone(OCI_Date *date, const otext *zone1, const otext *zone2)
Convert a date from one zone to another zone.
OCI_EXPORT unsigned int OCI_API OCI_CollGetSize(OCI_Coll *coll)
Returns the total number of elements of the given collection.
OCI_EXPORT OCI_HashTable *OCI_API OCI_HashCreate(unsigned int size, unsigned int type)
Create a hash table.
OCI_EXPORT const void *OCI_API OCI_HandleGetThreadID(OCI_Thread *thread)
Return OCI Thread ID (OCIThreadId *) of an OCILIB OCI_Thread object.
OCI_EXPORT boolean OCI_API OCI_MsgFree(OCI_Msg *msg)
Free a message object.
OCI_EXPORT boolean OCI_API OCI_RegisterUnsignedInt(OCI_Statement *stmt, const otext *name)
Register an unsigned integer output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_EnqueueSetVisibility(OCI_Enqueue *enqueue, unsigned int visibility)
Set whether the new message is enqueued as part of the current transaction.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetBusyCount(OCI_Pool *pool)
Return the current number of busy connections/sessions.
OCI_EXPORT OCI_Connection *OCI_API OCI_ConnectionCreate(const otext *db, const otext *user, const otext *pwd, unsigned int mode)
Create a physical connection to an Oracle database server.
OCI_EXPORT double OCI_API OCI_GetDouble(OCI_Resultset *rs, unsigned int index)
Return the current double value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_CollAssign(OCI_Coll *coll, OCI_Coll *coll_src)
Assign a collection to another one.
OCI_EXPORT unsigned int OCI_API OCI_SubscriptionGetTimeout(OCI_Subscription *sub)
Return the timeout of the given registered subscription.
OCI_EXPORT OCI_Agent *OCI_API OCI_MsgGetSender(OCI_Msg *msg)
Return the original sender of a message.
OCI_EXPORT boolean OCI_API OCI_SetHAHandler(POCI_HA_HANDLER handler)
Set the High availability (HA) user handler.
OCI_EXPORT boolean OCI_API OCI_DateToText(OCI_Date *date, const otext *fmt, int size, otext *str)
Convert a Date value from the given date handle to a string.
OCI_EXPORT const void *OCI_API OCI_HandleGetServer(OCI_Connection *con)
Return the OCI Server Handle (OCIServer *) of an OCILIB OCI_Connection object.
OCI_EXPORT short OCI_API OCI_ElemGetShort(OCI_Elem *elem)
Return the short value of the given collection element.
OCI_EXPORT const otext *OCI_API OCI_EventGetDatabase(OCI_Event *event)
Return the name of the database that generated the event.
OCI_EXPORT boolean OCI_API OCI_RegisterObject(OCI_Statement *stmt, const otext *name, OCI_TypeInfo *typinf)
Register an object output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_ObjectSetBigInt(OCI_Object *obj, const otext *attr, big_int value)
Set an object attribute of type big int.
struct OCI_File OCI_File
Oracle External Large objects:
OCI_EXPORT OCI_Lob *OCI_API OCI_LobCreate(OCI_Connection *con, unsigned int type)
Create a local temporary Lob instance.
struct OCI_Thread OCI_Thread
OCILIB encapsulation of OCI Threads.
OCI_EXPORT const otext *OCI_API OCI_GetDatabase(OCI_Connection *con)
Return the name of the connected database/service name.
OCI_EXPORT boolean OCI_API OCI_IntervalAdd(OCI_Interval *itv, OCI_Interval *itv2)
Adds an interval handle value to another.
OCI_EXPORT boolean OCI_API OCI_BindTimestamp(OCI_Statement *stmt, const otext *name, OCI_Timestamp *data)
Bind a timestamp variable.
OCI_EXPORT boolean OCI_API OCI_SetTrace(OCI_Connection *con, unsigned int trace, const otext *value)
Set tracing information to the session of the given connection.
OCI_EXPORT boolean OCI_API OCI_ObjectSetDate(OCI_Object *obj, const otext *attr, OCI_Date *value)
Set an object attribute of type Date.
OCI_EXPORT boolean OCI_API OCI_FetchNext(OCI_Resultset *rs)
Fetch the next row of the resultset.
OCI_EXPORT float OCI_API OCI_GetFloat(OCI_Resultset *rs, unsigned int index)
Return the current float value of the column at the given index in the resultset. ...
OCI_EXPORT const otext *OCI_API OCI_GetFormat(OCI_Connection *con, unsigned int type)
Return the format string for implicit string conversions of the given type.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfFiles(OCI_Statement *stmt, const otext *name, OCI_File **data, unsigned int type, unsigned int nbelem)
Bind an array of File handles.
OCI_EXPORT boolean OCI_API OCI_MsgSetRaw(OCI_Msg *msg, const void *raw, unsigned int size)
Set the RAW payload of the given message.
OCI_EXPORT boolean OCI_API OCI_MsgSetConsumers(OCI_Msg *msg, OCI_Agent **consumers, unsigned int count)
Set the recipient list of a message to enqueue.
OCI_EXPORT boolean OCI_API OCI_RegisterNumber(OCI_Statement *stmt, const otext *name)
Register a register output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_QueueTableMigrate(OCI_Connection *con, const otext *queue_table, const otext *compatible)
Migrate a queue table from one version to another.
OCI_EXPORT boolean OCI_API OCI_ObjectSetTimestamp(OCI_Object *obj, const otext *attr, OCI_Timestamp *value)
Set an object attribute of type Timestamp.
OCI_EXPORT boolean OCI_API OCI_RegisterLob(OCI_Statement *stmt, const otext *name, unsigned int type)
Register a lob output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_ThreadFree(OCI_Thread *thread)
Destroy a thread object.
OCI_EXPORT boolean OCI_API OCI_RefArrayFree(OCI_Ref **refs)
Free an array of Ref objects.
OCI_EXPORT const otext *OCI_API OCI_HashGetString(OCI_HashTable *table, const otext *key)
Return the string value associated to the given key.
OCI_EXPORT boolean OCI_API OCI_TimestampIntervalAdd(OCI_Timestamp *tmsp, OCI_Interval *itv)
Add an interval value to a timestamp value of a timestamp handle.
OCI_EXPORT OCI_Date *OCI_API OCI_ObjectGetDate(OCI_Object *obj, const otext *attr)
Return the date value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfStrings(OCI_Statement *stmt, const otext *name, otext *data, unsigned int len, unsigned int nbelem)
Bind an array of strings.
OCI_EXPORT boolean OCI_API OCI_ObjectGetSelfRef(OCI_Object *obj, OCI_Ref *ref)
Retrieve an Oracle Ref handle from an object and assign it to the given OCILIB OCI_Ref handle...
OCI_EXPORT boolean OCI_API OCI_PoolFree(OCI_Pool *pool)
Destroy a pool object.
OCI_EXPORT boolean OCI_API OCI_ElemSetNumber(OCI_Elem *elem, OCI_Number *value)
Set a number value to a collection element.
OCI_EXPORT OCI_Coll *OCI_API OCI_CollCreate(OCI_TypeInfo *typinf)
Create a local collection instance.
struct OCI_Number OCI_Number
Oracle NUMBER representation.
OCI_EXPORT unsigned int OCI_API OCI_GetFetchSize(OCI_Statement *stmt)
Return the number of rows fetched per internal server fetch call.
OCI_EXPORT boolean OCI_API OCI_ColumnGetNullable(OCI_Column *col)
Return the nullable attribute of the column.
OCI_EXPORT const otext *OCI_API OCI_FileGetName(OCI_File *file)
Return the name of the given file.
OCI_EXPORT unsigned int OCI_API OCI_GetStatementType(OCI_Statement *stmt)
Return the type of a SQL statement.
OCI_EXPORT boolean OCI_API OCI_QueueCreate(OCI_Connection *con, const otext *queue_name, const otext *queue_table, unsigned int queue_type, unsigned int max_retries, unsigned int retry_delay, unsigned int retention_time, boolean dependency_tracking, const otext *comment)
Create a queue.
OCI_EXPORT unsigned int OCI_API OCI_GetRaw(OCI_Resultset *rs, unsigned int index, void *buffer, unsigned int len)
Copy the current raw value of the column at the given index into the specified buffer.
OCI_EXPORT boolean OCI_API OCI_IntervalArrayFree(OCI_Interval **itvs)
Free an array of Interval objects.
OCI_EXPORT boolean OCI_API OCI_FileSeek(OCI_File *file, big_uint offset, unsigned int mode)
Perform a seek operation on the OCI_File content buffer.
OCI_EXPORT boolean OCI_API OCI_SetAutoCommit(OCI_Connection *con, boolean enable)
Enable / disable auto commit mode.
OCI_EXPORT boolean OCI_API OCI_LobIsTemporary(OCI_Lob *lob)
Check if the given lob is a temporary lob.
OCI_EXPORT boolean OCI_API OCI_DirPathSetColumn(OCI_DirPath *dp, unsigned int index, const otext *name, unsigned int maxsize, const otext *format)
Describe a column to load into the given table.
OCI_EXPORT boolean OCI_API OCI_NumberSetValue(OCI_Number *number, unsigned int type, void *value)
Assign the number value with the value of a native C numeric type.
OCI_EXPORT boolean OCI_API OCI_DirPathSetNoLog(OCI_DirPath *dp, boolean value)
Set the logging mode for the loading operation.
OCI_EXPORT boolean OCI_API OCI_IsConnected(OCI_Connection *con)
Returns TRUE is the given connection is still connected otherwise FALSE.
OCI_EXPORT boolean OCI_API OCI_QueueTableCreate(OCI_Connection *con, const otext *queue_table, const otext *queue_payload_type, const otext *storage_clause, const otext *sort_list, boolean multiple_consumers, unsigned int message_grouping, const otext *comment, unsigned int primary_instance, unsigned int secondary_instance, const otext *compatible)
Create a queue table for messages of the given type.
OCI_EXPORT OCI_Bind *OCI_API OCI_GetBind2(OCI_Statement *stmt, const otext *name)
Return a bind handle from its name.
OCI_EXPORT boolean OCI_API OCI_Prepare(OCI_Statement *stmt, const otext *sql)
Prepare a SQL statement or PL/SQL block.
OCI_EXPORT boolean OCI_API OCI_DequeueSetAgentList(OCI_Dequeue *dequeue, OCI_Agent **consumers, unsigned int count)
Set the Agent list to listen to message for.
OCI_EXPORT boolean OCI_API OCI_PoolSetTimeout(OCI_Pool *pool, unsigned int value)
Set the connections/sessions idle timeout.
OCI_EXPORT OCI_File *OCI_API OCI_GetFile(OCI_Resultset *rs, unsigned int index)
Return the current File value of the column at the given index in the resultset.
OCI_EXPORT OCI_Object **OCI_API OCI_ObjectArrayCreate(OCI_Connection *con, OCI_TypeInfo *typinf, unsigned int nbelem)
Create an array of Object objects.
OCI_EXPORT boolean OCI_API OCI_DateSetDateTime(OCI_Date *date, int year, int month, int day, int hour, int min, int sec)
Set the date and time portions if the given date handle.
OCI_EXPORT boolean OCI_API OCI_ObjectSetInt(OCI_Object *obj, const otext *attr, int value)
Set an object attribute of type int.
OCI_EXPORT big_uint OCI_API OCI_LobGetLength(OCI_Lob *lob)
Return the actual length of a lob.
OCI_EXPORT unsigned int OCI_API OCI_GetServerMajorVersion(OCI_Connection *con)
Return the major version number of the connected database server.
OCI_EXPORT boolean OCI_API OCI_DirPathSetEntry(OCI_DirPath *dp, unsigned int row, unsigned int index, void *value, unsigned size, boolean complete)
Set the value of the given row/column array entry.
OCI_EXPORT OCI_Lob *OCI_API OCI_ElemGetLob(OCI_Elem *elem)
Return the Lob value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_LobEnableBuffering(OCI_Lob *lob, boolean value)
Enable / disable buffering mode on the given lob handle.
void(* POCI_NOTIFY_AQ)(OCI_Dequeue *dequeue)
AQ notification callback prototype.
OCI_EXPORT unsigned int OCI_API OCI_GetStatementCacheSize(OCI_Connection *con)
Return the maximum number of statements to keep in the statement cache.
OCI_EXPORT boolean OCI_API OCI_SetTransaction(OCI_Connection *con, OCI_Transaction *trans)
Set a transaction to a connection.
OCI_EXPORT boolean OCI_API OCI_CollTrim(OCI_Coll *coll, unsigned int nb_elem)
Trims the given number of elements from the end of the collection.
OCI_EXPORT boolean OCI_API OCI_RefFree(OCI_Ref *ref)
Free a local Ref.
OCI_EXPORT OCI_Transaction *OCI_API OCI_GetTransaction(OCI_Connection *con)
Return the current transaction of the connection.
OCI_EXPORT boolean OCI_API OCI_DateNextDay(OCI_Date *date, const otext *day)
Gets the date of next day of the week, after a given date.
OCI_EXPORT boolean OCI_API OCI_Rollback(OCI_Connection *con)
Cancel current pending changes.
OCI_EXPORT OCI_TypeInfo *OCI_API OCI_ObjectGetTypeInfo(OCI_Object *obj)
Return the type info object associated to the object.
OCI_EXPORT unsigned int OCI_API OCI_LongGetSize(OCI_Long *lg)
Return the buffer size of a long object in bytes (OCI_BLONG) or character (OCI_CLONG) ...
OCI_EXPORT boolean OCI_API OCI_FileOpen(OCI_File *file)
Open a file for reading.
OCI_EXPORT boolean OCI_API OCI_FetchSeek(OCI_Resultset *rs, unsigned int mode, int offset)
Custom Fetch of the resultset.
OCI_EXPORT boolean OCI_API OCI_IntervalGetYearMonth(OCI_Interval *itv, int *year, int *month)
Return the year / month portion of an interval handle.
OCI_EXPORT boolean OCI_API OCI_IntervalSetDaySecond(OCI_Interval *itv, int day, int hour, int min, int sec, int fsec)
Set the day / time portion if the given interval handle.
OCI_EXPORT boolean OCI_API OCI_ElemSetColl(OCI_Elem *elem, OCI_Coll *value)
Assign a Collection handle to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_DequeueGetVisibility(OCI_Dequeue *dequeue)
Get the dequeuing/locking behavior.
OCI_EXPORT boolean OCI_API OCI_ObjectSetUnsignedShort(OCI_Object *obj, const otext *attr, unsigned short value)
Set an object attribute of type unsigned short.
OCI_EXPORT boolean OCI_API OCI_ElemSetDate(OCI_Elem *elem, OCI_Date *value)
Assign a Date handle to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_GetDataLength(OCI_Resultset *rs, unsigned int index)
Return the current row data length of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_ReleaseResultsets(OCI_Statement *stmt)
Free the statement resultsets.
OCI_EXPORT boolean OCI_API OCI_RegisterString(OCI_Statement *stmt, const otext *name, unsigned int len)
Register a string output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_RegisterShort(OCI_Statement *stmt, const otext *name)
Register a short output bind placeholder.
OCI_EXPORT OCI_Object *OCI_API OCI_ElemGetObject(OCI_Elem *elem)
Return the object value of the given collection element.
OCI_EXPORT unsigned int OCI_API OCI_GetSQLCommand(OCI_Statement *stmt)
Return the Oracle SQL code the command held by the statement handle.
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetRowCount(OCI_DirPath *dp)
Return the number of rows successfully loaded into the database so far.
OCI_EXPORT boolean OCI_API OCI_TimestampAssign(OCI_Timestamp *tmsp, OCI_Timestamp *tmsp_src)
Assign the value of a timestamp handle to another one.
OCI_EXPORT boolean OCI_API OCI_DirPathSetConvertMode(OCI_DirPath *dp, unsigned int mode)
Set the direct path conversion mode.
OCI_EXPORT int OCI_API OCI_ColumnGetFractionalPrecision(OCI_Column *col)
Return the fractional precision of the column for timestamp and interval columns. ...
OCI_EXPORT unsigned int OCI_API OCI_GetPrefetchMemory(OCI_Statement *stmt)
Return the amount of memory used to retrieve rows pre-fetched by OCI Client.
OCI_EXPORT boolean OCI_API OCI_SetPrefetchSize(OCI_Statement *stmt, unsigned int size)
Set the number of rows pre-fetched by OCI Client.
OCI_EXPORT boolean OCI_API OCI_DequeueGetRelativeMsgID(OCI_Dequeue *dequeue, void *id, unsigned int *len)
Get the message identifier of the message to be dequeued.
OCI_EXPORT boolean OCI_API OCI_DequeueSetCorrelation(OCI_Dequeue *dequeue, const otext *pattern)
set the correlation identifier of the message to be dequeued
OCI_EXPORT boolean OCI_API OCI_DirPathSetParallel(OCI_DirPath *dp, boolean value)
Set the parallel loading mode.
OCI_EXPORT int OCI_API OCI_NumberAssign(OCI_Number *number, OCI_Number *number_src)
Assign the value of a number handle to another one.
void(* POCI_THREADKEYDEST)(void *data)
Thread key destructor prototype.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfRefs(OCI_Statement *stmt, const otext *name, OCI_Ref **data, OCI_TypeInfo *typinf, unsigned int nbelem)
Bind an array of Ref handles.
OCI_EXPORT boolean OCI_API OCI_QueueAlter(OCI_Connection *con, const otext *queue_name, unsigned int max_retries, unsigned int retry_delay, unsigned int retention_time, const otext *comment)
Alter the given queue.
OCI_EXPORT OCI_Dequeue *OCI_API OCI_DequeueCreate(OCI_TypeInfo *typinf, const otext *name)
Create a Dequeue object for the given queue.
OCI_EXPORT OCI_Error *OCI_API OCI_GetBatchError(OCI_Statement *stmt)
Returns the first or next error that occurred within a DML array statement execution.
OCI_EXPORT OCI_HashValue *OCI_API OCI_HashGetValue(OCI_HashTable *table, const otext *key)
Return the first hash slot that matches the key.
struct OCI_HashValue OCI_HashValue
Hash table entry value.
OCI_EXPORT OCI_Resultset *OCI_API OCI_GetNextResultset(OCI_Statement *stmt)
Retrieve the next available resultset.
OCI_EXPORT unsigned int OCI_API OCI_TransactionGetTimeout(OCI_Transaction *trans)
Return global transaction Timeout.
OCI_EXPORT boolean OCI_API OCI_TimestampArrayFree(OCI_Timestamp **tmsps)
Free an array of timestamp objects.
OCI_EXPORT boolean OCI_API OCI_ElemSetInt(OCI_Elem *elem, int value)
Set a int value to a collection element.
OCI_EXPORT boolean OCI_API OCI_LongFree(OCI_Long *lg)
Free a local temporary long.
OCI_EXPORT boolean OCI_API OCI_SetStructNumericType(OCI_Resultset *rs, unsigned int index, unsigned int type)
set the numeric data type of the given structure member (identified from position in the resultset) t...
struct OCI_Long OCI_Long
Oracle Long data type.
OCI_EXPORT double OCI_API OCI_ElemGetDouble(OCI_Elem *elem)
Return the Double value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_RegisterRef(OCI_Statement *stmt, const otext *name, OCI_TypeInfo *typinf)
Register a Ref output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_TimestampToText(OCI_Timestamp *tmsp, const otext *fmt, int size, otext *str, int precision)
Convert a timestamp value from the given timestamp handle to a string.
OCI_EXPORT short OCI_API OCI_GetShort(OCI_Resultset *rs, unsigned int index)
Return the current short value of the column at the given index in the resultset. ...
OCI_EXPORT boolean OCI_API OCI_SetPrefetchMemory(OCI_Statement *stmt, unsigned int size)
Set the amount of memory pre-fetched by OCI Client.
OCI_EXPORT boolean OCI_API OCI_CollGetElem2(OCI_Coll *coll, unsigned int index, OCI_Elem *elem)
Return the element at the given position in the collection.
OCI_EXPORT OCI_Number *OCI_API OCI_GetNumber(OCI_Resultset *rs, unsigned int index)
Return the current Number value of the column at the given index in the resultset.
OCI_EXPORT const otext *OCI_API OCI_EventGetRowid(OCI_Event *event)
Return the rowid of the altered database object row.
struct OCI_TypeInfo OCI_TypeInfo
Type info metadata handle.
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetErrorRow(OCI_DirPath *dp)
Return the index of a row which caused an error during data conversion.
OCI_EXPORT boolean OCI_API OCI_ObjectGetBoolean(OCI_Object *obj, const otext *attr)
Return the boolean value of the given object attribute (ONLY for PL/SQL records)
OCI_EXPORT const otext *OCI_API OCI_ElemGetString(OCI_Elem *elem)
Return the String value of the given collection element.
OCI_EXPORT const otext *OCI_API OCI_GetServiceName(OCI_Connection *con)
Return the Oracle server service name of the connected database/service name.
OCI_EXPORT OCI_Object *OCI_API OCI_MsgGetObject(OCI_Msg *msg)
Get the object payload of the given message.
OCI_EXPORT boolean OCI_API OCI_BindShort(OCI_Statement *stmt, const otext *name, short *data)
Bind an short variable.
OCI_EXPORT boolean OCI_API OCI_ElemSetDouble(OCI_Elem *elem, double value)
Set a double value to a collection element.
OCI_EXPORT const otext *OCI_API OCI_DequeueGetConsumer(OCI_Dequeue *dequeue)
Get the current consumer name associated with the dequeuing process.
OCI_EXPORT boolean OCI_API OCI_ElemSetObject(OCI_Elem *elem, OCI_Object *value)
Assign an Object handle to a collection element.
OCI_EXPORT unsigned int OCI_API OCI_GetUnsignedInt(OCI_Resultset *rs, unsigned int index)
Return the current unsigned integer value of the column at the given index in the resultset...
OCI_EXPORT boolean OCI_API OCI_RefIsNull(OCI_Ref *ref)
Check if the Ref points to an object or not.
OCI_EXPORT boolean OCI_API OCI_HashAddPointer(OCI_HashTable *table, const otext *key, void *value)
Adds a pair string key / pointer value to the hash table.
OCI_EXPORT unsigned int OCI_API OCI_GetOCIRuntimeVersion(void)
Return the version of OCI used at runtime.
OCI_EXPORT boolean OCI_API OCI_BindFloat(OCI_Statement *stmt, const otext *name, float *data)
Bind a float variable.
OCI_EXPORT boolean OCI_API OCI_HashAddString(OCI_HashTable *table, const otext *key, const otext *value)
Add a pair string key / string value to the hash table.
OCI_EXPORT boolean OCI_API OCI_IsNull2(OCI_Resultset *rs, const otext *name)
Check if the current row value is null for the column of the given name in the resultset.
OCI_EXPORT boolean OCI_API OCI_TimestampGetDate(OCI_Timestamp *tmsp, int *year, int *month, int *day)
Extract the date part from a timestamp handle.
OCI_EXPORT boolean OCI_API OCI_DequeueSetMode(OCI_Dequeue *dequeue, unsigned int mode)
Set the dequeuing/locking behavior.
OCI_EXPORT big_uint OCI_API OCI_LobGetMaxSize(OCI_Lob *lob)
Return the maximum size that the lob can contain.
OCI_EXPORT int OCI_API OCI_ElemGetInt(OCI_Elem *elem)
Return the int value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_FileClose(OCI_File *file)
Close a file.
OCI_EXPORT boolean OCI_API OCI_DirPathPrepare(OCI_DirPath *dp)
Prepares the OCI direct path load interface before any rows can be converted or loaded.
OCI_EXPORT void *OCI_API OCI_LongGetBuffer(OCI_Long *lg)
Return the internal buffer of an OCI_Long object read from a fetch sequence.
OCI_EXPORT OCI_Date **OCI_API OCI_DateArrayCreate(OCI_Connection *con, unsigned int nbelem)
Create an array of date object.
OCI_EXPORT boolean OCI_API OCI_SetFetchSize(OCI_Statement *stmt, unsigned int size)
Set the number of rows fetched per internal server fetch call.
OCI_EXPORT OCI_Coll **OCI_API OCI_CollArrayCreate(OCI_Connection *con, OCI_TypeInfo *typinf, unsigned int nbelem)
Create an array of Collection object.
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetMaxRows(OCI_DirPath *dp)
Return the maximum number of rows allocated in the OCI and OCILIB internal arrays of rows...
OCI_EXPORT unsigned int OCI_API OCI_EnqueueGetSequenceDeviation(OCI_Enqueue *enqueue)
Return the sequence deviation of messages to enqueue to the queue.
OCI_EXPORT OCI_Msg *OCI_API OCI_DequeueGet(OCI_Dequeue *dequeue)
Dequeue messages from the given queue.
OCI_EXPORT OCI_Agent *OCI_API OCI_AgentCreate(OCI_Connection *con, const otext *name, const otext *address)
Create an AQ agent object.
struct OCI_HashTable OCI_HashTable
OCILIB implementation of hash tables.
OCI_EXPORT unsigned int OCI_API OCI_GetBindMode(OCI_Statement *stmt)
Return the binding mode of a SQL statement.
OCI_EXPORT big_int OCI_API OCI_ObjectGetBigInt(OCI_Object *obj, const otext *attr)
Return the big integer value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_TimestampSysTimestamp(OCI_Timestamp *tmsp)
Stores the system current date and time as a timestamp value with time zone into the timestamp handle...
OCI_EXPORT OCI_Elem *OCI_API OCI_IterGetPrev(OCI_Iter *iter)
Get the previous element in the collection.
OCI_EXPORT unsigned int OCI_API OCI_CollGetType(OCI_Coll *coll)
Return the collection type.
OCI_EXPORT boolean OCI_API OCI_CollToText(OCI_Coll *coll, unsigned int *size, otext *str)
Convert a collection handle value to a string.
OCI_EXPORT boolean OCI_API OCI_SetSessionTag(OCI_Connection *con, const otext *tag)
Associate a tag to the given connection/session.
OCI_EXPORT boolean OCI_API OCI_BindIsNullAtPos(OCI_Bind *bnd, unsigned int position)
Check if the current entry value at the given index of the binded array is marked as NULL...
OCI_EXPORT boolean OCI_API OCI_MsgSetExpiration(OCI_Msg *msg, int value)
set the duration that the message is available for dequeuing
OCI_EXPORT unsigned int OCI_API OCI_TimestampGetType(OCI_Timestamp *tmsp)
Return the type of the given Timestamp object.
OCI_EXPORT boolean OCI_API OCI_IntervalFromText(OCI_Interval *itv, const otext *str)
Convert a string to an interval and store it in the given interval handle.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_TimestampCreate(OCI_Connection *con, unsigned int type)
Create a local Timestamp instance.
OCI_EXPORT boolean OCI_API OCI_ObjectSetInterval(OCI_Object *obj, const otext *attr, OCI_Interval *value)
Set an object attribute of type Interval.
OCI_EXPORT boolean OCI_API OCI_SetStatementCacheSize(OCI_Connection *con, unsigned int value)
Set the maximum number of statements to keep in the statement cache.
OCI_EXPORT boolean OCI_API OCI_ObjectSetBoolean(OCI_Object *obj, const otext *attr, boolean value)
Set an object attribute of type boolean (ONLY for PL/SQL records)
OCI_EXPORT unsigned int OCI_API OCI_LongGetType(OCI_Long *lg)
Return the type of the given Long object.
OCI_EXPORT OCI_Thread *OCI_API OCI_ThreadCreate(void)
Create a Thread object.
OCI_EXPORT boolean OCI_API OCI_SetFormat(OCI_Connection *con, unsigned int type, const otext *format)
Set the format string for implicit string conversions of the given type.
OCI_EXPORT boolean OCI_API OCI_ObjectSetFloat(OCI_Object *obj, const otext *attr, float value)
Set an object attribute of type float.
OCI_EXPORT OCI_Coll *OCI_API OCI_ObjectGetColl(OCI_Object *obj, const otext *attr)
Return the collection value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_SetLongMode(OCI_Statement *stmt, unsigned int mode)
Set the long data type handling mode of a SQL statement.
OCI_EXPORT boolean OCI_API OCI_AgentFree(OCI_Agent *agent)
Free an AQ agent object.
OCI_EXPORT OCI_Long *OCI_API OCI_GetLong2(OCI_Resultset *rs, const otext *name)
Return the current Long value of the column from its name in the resultset.
OCI_EXPORT int OCI_API OCI_IntervalCheck(OCI_Interval *itv)
Check if the given interval is valid.
OCI_EXPORT OCI_Connection *OCI_API OCI_StatementGetConnection(OCI_Statement *stmt)
Return the connection handle associated with a statement handle.
OCI_EXPORT boolean OCI_API OCI_QueueTableDrop(OCI_Connection *con, const otext *queue_table, boolean force)
Drop the given queue table.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_GetTimestamp(OCI_Resultset *rs, unsigned int index)
Return the current timestamp value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_BindLong(OCI_Statement *stmt, const otext *name, OCI_Long *data, unsigned int size)
Bind a Long variable.
OCI_EXPORT unsigned int OCI_API OCI_GetBindCount(OCI_Statement *stmt)
Return the number of binds currently associated to a statement.
OCI_EXPORT OCI_Agent *OCI_API OCI_DequeueListen(OCI_Dequeue *dequeue, int timeout)
Listen for messages that match any recipient of the associated Agent list.
OCI_EXPORT boolean OCI_API OCI_MsgSetPriority(OCI_Msg *msg, int value)
Set the priority of the message.
OCI_EXPORT int OCI_API OCI_MsgGetEnqueueDelay(OCI_Msg *msg)
Return the number of seconds that a message is delayed for dequeuing.
OCI_EXPORT OCI_TypeInfo *OCI_API OCI_ColumnGetTypeInfo(OCI_Column *col)
Return the type information object associated to the column.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetTimeout(OCI_Pool *pool)
Get the idle timeout for connections/sessions in the pool.
OCI_EXPORT boolean OCI_API OCI_RegisterTimestamp(OCI_Statement *stmt, const otext *name, unsigned int type)
Register a timestamp output bind placeholder.
OCI_EXPORT OCI_File *OCI_API OCI_ObjectGetFile(OCI_Object *obj, const otext *attr)
Return the file value of the given object attribute.
OCI_EXPORT OCI_Interval *OCI_API OCI_ObjectGetInterval(OCI_Object *obj, const otext *attr)
Return the interval value of the given object attribute.
OCI_EXPORT boolean OCI_API OCI_IntervalFree(OCI_Interval *itv)
Free an OCI_Interval handle.
OCI_EXPORT boolean OCI_API OCI_DirPathSave(OCI_DirPath *dp)
Execute a data save-point (server side)
OCI_EXPORT boolean OCI_API OCI_BindSetNotNull(OCI_Bind *bnd)
Set the bind variable to NOT null.
OCI_EXPORT boolean OCI_API OCI_MsgSetEnqueueDelay(OCI_Msg *msg, int value)
set the number of seconds to delay the enqueued message
OCI_EXPORT boolean OCI_API OCI_DateGetDate(OCI_Date *date, int *year, int *month, int *day)
Extract the date part from a date handle.
OCI_EXPORT boolean OCI_API OCI_TimestampFromCTime(OCI_Timestamp *tmsp, struct tm *ptm, time_t t)
Affect ISO C time data types values to an OCI_Timestamp handle.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetSize(OCI_Column *col)
Return the size of the column.
OCI_EXPORT boolean OCI_API OCI_TransactionStart(OCI_Transaction *trans)
Start global transaction.
OCI_EXPORT unsigned int OCI_API OCI_BindGetAllocationMode(OCI_Bind *bnd)
Get the allocaton mode of a bind handle.
OCI_EXPORT unsigned int OCI_API OCI_GetColumnIndex(OCI_Resultset *rs, const otext *name)
Return the index of the column in the result from its name.
OCI_EXPORT boolean OCI_API OCI_BindColl(OCI_Statement *stmt, const otext *name, OCI_Coll *data)
Bind a Collection variable.
OCI_EXPORT unsigned int OCI_API OCI_LongWrite(OCI_Long *lg, void *buffer, unsigned int len)
Write a buffer into a Long.
struct OCI_Coll OCI_Coll
Oracle Collections (VARRAYs and Nested Tables) representation.
OCI_EXPORT boolean OCI_API OCI_QueueDrop(OCI_Connection *con, const otext *queue_name)
Drop the given queue.
OCI_EXPORT int OCI_API OCI_ColumnGetPrecision(OCI_Column *col)
Return the precision of the column for numeric columns.
OCI_EXPORT const otext *OCI_API OCI_GetServerName(OCI_Connection *con)
Return the Oracle server machine name of the connected database/service name.
OCI_EXPORT boolean OCI_API OCI_DequeueUnsubscribe(OCI_Dequeue *dequeue)
Unsubscribe for asynchronous messages notifications.
OCI_EXPORT boolean OCI_API OCI_TransactionStop(OCI_Transaction *trans)
Stop current global transaction.
OCI_EXPORT const void *OCI_API OCI_HandleGetFile(OCI_File *file)
Return the OCI LobLocator Handle (OCILobLocator *) of an OCILIB OCI_File object.
OCI_EXPORT boolean OCI_API OCI_NumberFromText(OCI_Number *number, const otext *str, const otext *fmt)
Convert a string to a number and store it in the given number handle.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfNumbers(OCI_Statement *stmt, const otext *name, OCI_Number **data, unsigned int nbelem)
Bind an array of Number.
OCI_EXPORT unsigned int OCI_API OCI_DirPathGetCurrentRows(OCI_DirPath *dp)
Return the current number of rows used in the OCILIB internal arrays of rows.
OCI_EXPORT boolean OCI_API OCI_MsgSetCorrelation(OCI_Msg *msg, const otext *correlation)
set the correlation identifier of the message
OCI_EXPORT unsigned int OCI_API OCI_ErrorGetRow(OCI_Error *err)
Return the row index which caused an error during statement execution.
OCI_EXPORT boolean OCI_API OCI_ElemFree(OCI_Elem *elem)
Free a local collection element.
OCI_EXPORT const otext *OCI_API OCI_AgentGetName(OCI_Agent *agent)
Get the given AQ agent name.
OCI_EXPORT OCI_DirPath *OCI_API OCI_DirPathCreate(OCI_TypeInfo *typinf, const otext *partition, unsigned int nb_cols, unsigned int nb_rows)
Create a direct path object.
OCI_EXPORT boolean OCI_API OCI_LobSeek(OCI_Lob *lob, big_uint offset, unsigned int mode)
Perform a seek operation on the OCI_lob content buffer.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfObjects(OCI_Statement *stmt, const otext *name, OCI_Object **data, OCI_TypeInfo *typinf, unsigned int nbelem)
Bind an array of object handles.
struct OCI_Elem OCI_Elem
Oracle Collection item representation.
OCI_EXPORT boolean OCI_API OCI_DirPathFlushRow(OCI_DirPath *dp)
Flushes a partially loaded row from server.
OCI_EXPORT boolean OCI_API OCI_ElemSetTimestamp(OCI_Elem *elem, OCI_Timestamp *value)
Assign a Timestamp handle to a collection element.
OCI_EXPORT boolean OCI_API OCI_Initialize(POCI_ERROR err_handler, const otext *lib_path, unsigned int mode)
Initialize the library.
OCI_EXPORT const otext *OCI_API OCI_GetSql(OCI_Statement *stmt)
Return the last SQL or PL/SQL statement prepared or executed by the statement.
OCI_EXPORT OCI_Number *OCI_API OCI_ObjectGetNumber(OCI_Object *obj, const otext *attr)
Return the number value of the given object attribute.
OCI_EXPORT OCI_Coll *OCI_API OCI_GetColl2(OCI_Resultset *rs, const otext *name)
Return the current Collection value of the column from its name in the resultset. ...
OCI_EXPORT boolean OCI_API OCI_ObjectSetString(OCI_Object *obj, const otext *attr, const otext *value)
Set an object attribute of type string.
OCI_EXPORT big_uint OCI_API OCI_ElemGetUnsignedBigInt(OCI_Elem *elem)
Return the unsigned big int value of the given collection element.
OCI_EXPORT unsigned int OCI_API OCI_PoolGetMin(OCI_Pool *pool)
Return the minimum number of connections/sessions that can be opened to the database.
OCI_EXPORT OCI_Timestamp **OCI_API OCI_TimestampArrayCreate(OCI_Connection *con, unsigned int type, unsigned int nbelem)
Create an array of timestamp object.
OCI_EXPORT boolean OCI_API OCI_FileArrayFree(OCI_File **files)
Free an array of file objects.
OCI_EXPORT int OCI_API OCI_HashGetInt(OCI_HashTable *table, const otext *key)
Return the integer value associated to the given key.
OCI_EXPORT int OCI_API OCI_MsgGetAttemptCount(OCI_Msg *msg)
Return the number of attempts that have been made to dequeue the message.
OCI_EXPORT boolean OCI_API OCI_ElemSetShort(OCI_Elem *elem, short value)
Set a short value to a collection element.
struct OCI_Object OCI_Object
Oracle Named types representation.
OCI_EXPORT unsigned int OCI_API OCI_BindGetDataCount(OCI_Bind *bnd)
Return the number of elements of the bind handle.
OCI_EXPORT OCI_Mutex *OCI_API OCI_MutexCreate(void)
Create a Mutex object.
OCI_EXPORT OCI_Long *OCI_API OCI_LongCreate(OCI_Statement *stmt, unsigned int type)
Create a local temporary Long instance.
OCI_EXPORT boolean OCI_API OCI_IntervalAssign(OCI_Interval *itv, OCI_Interval *itv_src)
Assign the value of a interval handle to another one.
OCI_EXPORT int OCI_API OCI_IntervalCompare(OCI_Interval *itv, OCI_Interval *itv2)
Compares two interval handles.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfBigInts(OCI_Statement *stmt, const otext *name, big_int *data, unsigned int nbelem)
Bind an array of big integers.
OCI_EXPORT OCI_Timestamp *OCI_API OCI_ElemGetTimestamp(OCI_Elem *elem)
Return the Timestamp value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_TimestampToCTime(OCI_Timestamp *tmsp, struct tm *ptm, time_t *pt)
Affect an OCI_Timestamp handle value to ISO C time data types.
struct OCI_Column OCI_Column
Oracle SQL Column and Type member representation.
OCI_EXPORT OCI_Elem *OCI_API OCI_IterGetNext(OCI_Iter *iter)
Get the next element in the collection.
OCI_EXPORT unsigned int OCI_API OCI_GetDefaultLobPrefetchSize(OCI_Connection *con)
Return the default LOB prefetch buffer size for the connection.
OCI_EXPORT boolean OCI_API OCI_LobFree(OCI_Lob *lob)
Free a local temporary lob.
OCI_EXPORT unsigned int OCI_API OCI_ColumnGetType(OCI_Column *col)
Return the type of the given column.
OCI_EXPORT OCI_Object *OCI_API OCI_GetObject(OCI_Resultset *rs, unsigned int index)
Return the current Object value of the column at the given index in the resultset.
OCI_EXPORT boolean OCI_API OCI_TimestampGetTimeZoneOffset(OCI_Timestamp *tmsp, int *hour, int *min)
Return the time zone (hour, minute) portion of a timestamp handle.
OCI_EXPORT boolean OCI_API OCI_BindSetNull(OCI_Bind *bnd)
Set the bind variable to null.
OCI_EXPORT boolean OCI_API OCI_IterFree(OCI_Iter *iter)
Free an iterator handle.
OCI_EXPORT boolean OCI_API OCI_EnqueuePut(OCI_Enqueue *enqueue, OCI_Msg *msg)
Enqueue a message on the queue associated to the Enqueue object.
OCI_EXPORT boolean OCI_API OCI_TransactionResume(OCI_Transaction *trans)
Resume a stopped global transaction.
OCI_EXPORT unsigned int OCI_API OCI_GetSqlErrorPos(OCI_Statement *stmt)
Return the error position (in terms of characters) in the SQL statement where the error occurred in c...
OCI_EXPORT boolean OCI_API OCI_QueueStop(OCI_Connection *con, const otext *queue_name, boolean enqueue, boolean dequeue, boolean wait)
Stop enqueuing or dequeuing or both on the given queue.
OCI_EXPORT boolean OCI_API OCI_LobAppendLob(OCI_Lob *lob, OCI_Lob *lob_src)
Append a source LOB at the end of a destination LOB.
struct OCI_Iter OCI_Iter
Oracle Collection iterator representation.
OCI_EXPORT boolean OCI_API OCI_MsgSetExceptionQueue(OCI_Msg *msg, const otext *queue)
Set the name of the queue to which the message is moved to if it cannot be processed successfully...
OCI_EXPORT boolean OCI_API OCI_NumberArrayFree(OCI_Number **numbers)
Free an array of number objects.
OCI_EXPORT boolean OCI_API OCI_RegisterInterval(OCI_Statement *stmt, const otext *name, unsigned int type)
Register an interval output bind placeholder.
struct OCI_Error OCI_Error
Encapsulates an Oracle or OCILIB exception.
OCI_EXPORT unsigned int OCI_API OCI_HashGetType(OCI_HashTable *table)
Return the type of the hash table.
OCI_EXPORT boolean OCI_API OCI_Parse(OCI_Statement *stmt, const otext *sql)
Parse a SQL statement or PL/SQL block.
OCI_EXPORT boolean OCI_API OCI_IntervalSetYearMonth(OCI_Interval *itv, int year, int month)
Set the year / month portion if the given Interval handle.
OCI_EXPORT OCI_Statement *OCI_API OCI_ErrorGetStatement(OCI_Error *err)
Retrieve statement handle within the error occurred.
OCI_EXPORT const void *OCI_API OCI_HandleGetThread(OCI_Thread *thread)
Return OCI Thread handle (OCIThreadHandle *) of an OCILIB OCI_Thread object.
OCI_EXPORT boolean OCI_API OCI_SetFetchMode(OCI_Statement *stmt, unsigned int mode)
Set the fetch mode of a SQL statement.
OCI_EXPORT OCI_Number *OCI_API OCI_GetNumber2(OCI_Resultset *rs, const otext *name)
Return the current number value of the column from its name in the resultset.
OCI_EXPORT boolean OCI_API OCI_BindArrayOfColls(OCI_Statement *stmt, const otext *name, OCI_Coll **data, OCI_TypeInfo *typinf, unsigned int nbelem)
Bind an array of Collection handles.
OCI_EXPORT boolean OCI_API OCI_DirPathSetDateFormat(OCI_DirPath *dp, const otext *format)
Set the default date format string for input conversion.
OCI_EXPORT boolean OCI_API OCI_DateToCTime(OCI_Date *date, struct tm *ptm, time_t *pt)
Affect an OCI_Date handle value to ISO C time data types.
OCI_EXPORT boolean OCI_API OCI_DequeueSetRelativeMsgID(OCI_Dequeue *dequeue, const void *id, unsigned int len)
Set the message identifier of the message to be dequeued.
OCI_EXPORT boolean OCI_API OCI_RegisterRaw(OCI_Statement *stmt, const otext *name, unsigned int len)
Register an raw output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_DirPathFinish(OCI_DirPath *dp)
Terminate a direct path operation and commit changes into the database.
OCI_EXPORT boolean OCI_API OCI_EnqueueFree(OCI_Enqueue *enqueue)
Free a Enqueue object.
OCI_EXPORT OCI_HashEntry *OCI_API OCI_HashLookup(OCI_HashTable *table, const otext *key, boolean create)
Lookup for an entry matching the key in the table.
OCI_EXPORT boolean OCI_API OCI_RefAssign(OCI_Ref *ref, OCI_Ref *ref_src)
Assign a Ref to another one.
OCI_EXPORT const otext *OCI_API OCI_GetTrace(OCI_Connection *con, unsigned int trace)
Get the current trace for the trace type from the given connection.
OCI_EXPORT OCI_Msg *OCI_API OCI_MsgCreate(OCI_TypeInfo *typinf)
Create a message object based on the given payload type.
OCI_EXPORT boolean OCI_API OCI_AgentSetAddress(OCI_Agent *agent, const otext *address)
Set the given AQ agent address.
OCI_EXPORT boolean OCI_API OCI_LobFlush(OCI_Lob *lob)
Flush Lob content to the server.
OCI_EXPORT OCI_Lob *OCI_API OCI_GetLob(OCI_Resultset *rs, unsigned int index)
Return the current lob value of the column at the given index in the resultset.
struct OCI_Event OCI_Event
OCILIB encapsulation of Oracle DCN event.
OCI_EXPORT boolean OCI_API OCI_BindUnsignedShort(OCI_Statement *stmt, const otext *name, unsigned short *data)
Bind an unsigned short variable.
OCI_EXPORT OCI_Subscription *OCI_API OCI_SubscriptionRegister(OCI_Connection *con, const otext *name, unsigned int type, POCI_NOTIFY handler, unsigned int port, unsigned int timeout)
Register a notification against the given database.
OCI_EXPORT OCI_Ref *OCI_API OCI_ElemGetRef(OCI_Elem *elem)
Return the Ref value of the given collection element.
OCI_EXPORT boolean OCI_API OCI_RegisterFloat(OCI_Statement *stmt, const otext *name)
Register a float output bind placeholder.
OCI_EXPORT boolean OCI_API OCI_NumberMultiply(OCI_Number *number, unsigned int type, void *value)
Multiply the given number with the value of a native C numeric.
OCI_EXPORT OCI_Ref **OCI_API OCI_RefArrayCreate(OCI_Connection *con, OCI_TypeInfo *typinf, unsigned int nbelem)
Create an array of Ref object.
OCI_EXPORT boolean OCI_API OCI_ElemSetFloat(OCI_Elem *elem, float value)
Set a float value to a collection element.
OCI_EXPORT const void *OCI_API OCI_HandleGetTransaction(OCI_Transaction *trans)
Return the OCI Transaction Handle (OCITrans *) of an OCILIB OCI_Transaction object.
OCI_EXPORT unsigned int OCI_API OCI_ObjectGetRawSize(OCI_Object *obj, const otext *attr)
Return the raw attribute value size of the given object attribute into the given buffer.
struct OCI_Lob OCI_Lob
Oracle Internal Large objects:
OCI_EXPORT boolean OCI_API OCI_BindRef(OCI_Statement *stmt, const otext *name, OCI_Ref *data)
Bind a Ref variable.
OCI_EXPORT const void *OCI_API OCI_HandleGetDirPathColArray(OCI_DirPath *dp)
Return OCI DirectPath Column array handle (OCIDirPathColArray *) of an OCILIB OCI_DirPath object...
OCI_EXPORT boolean OCI_API OCI_FileIsEqual(OCI_File *file, OCI_File *file2)
Compare two file handle for equality.
OCI_EXPORT boolean OCI_API OCI_Cleanup(void)
Clean up all resources allocated by the library.
OCI_EXPORT const void *OCI_API OCI_HandleGetRef(OCI_Ref *ref)
Return OCI Ref Handle (OCIRef *) of an OCILIB OCI_Ref object.
OCI_EXPORT const void *OCI_API OCI_HandleGetInterval(OCI_Interval *itv)
Return OCI Interval Handle (OCIInterval *) of an OCILIB OCI_Interval object.
OCI_EXPORT unsigned int OCI_API OCI_BindGetType(OCI_Bind *bnd)
Return the OCILIB type of the given bind.
OCI_EXPORT OCI_Number *OCI_API OCI_NumberCreate(OCI_Connection *con)
Create a local number object.
OCI_EXPORT OCI_Pool *OCI_API OCI_PoolCreate(const otext *db, const otext *user, const otext *pwd, unsigned int type, unsigned int mode, unsigned int min_con, unsigned int max_con, unsigned int incr_con)
Create an Oracle pool of connections or sessions.
OCI_EXPORT boolean OCI_API OCI_BindNumber(OCI_Statement *stmt, const otext *name, OCI_Number *data)
Bind an Number variable.
OCI_EXPORT boolean OCI_API OCI_TimestampConvert(OCI_Timestamp *tmsp, OCI_Timestamp *tmsp_src)
Convert one timestamp value from one type to another.