📄 oci_defs.h
字号:
/*
+----------------------------------------------------------------------+
| |
| OCILIB - C Driver for Oracle |
| |
| (C Wrapper for Oracle OCI) |
| |
+----------------------------------------------------------------------+
| Website : http://ocilib.net |
+----------------------------------------------------------------------+
| Copyright (c) 2007-2009 Vincent ROGIER |
+----------------------------------------------------------------------+
| This library is free software; you can redistribute it and/or |
| modify it under the terms of the GNU Library General Public |
| License as published by the Free Software Foundation; either |
| version 2 of the License, or (at your option) any later version. |
| |
| This library is distributed in the hope that it will be useful, |
| but WITHOUT ANY WARRANTY; without even the implied warranty of |
| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU |
| Library General Public License for more details. |
| |
| You should have received a copy of the GNU Library General Public |
| License along with this library; if not, write to the Free |
| Software Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA. |
+----------------------------------------------------------------------+
| Author: Vincent ROGIER <vince.rogier@gmail.com> |
+----------------------------------------------------------------------+
+----------------------------------------------------------------------+
| IMPORTANT NOTICE |
+----------------------------------------------------------------------+
| |
| THIS FILE CONTAINS CONSTANTS AND STRUCTURES DECLARATIONS THAT WERE |
| PICKED UP FROM ORACLE PUBLIC HEADER FILES. |
| |
| SO THE CONTENT OF THIS FILE IS UNDER ORACLE COPYRIGHT AND THE |
| DECLARATIONS REPRODUCED HERE ARE ORIGINALLY WRITTEN BY ORACLE |
| CORPORATION. |
| |
| THE AUTHOR OF OCILIB LIBRARY HAS NOT WRITTEN THE CONTENT OF THIS |
| FILE AND HAS PARTIALLY INTEGRATED SOME ORACLE OCI DEFINITONS TO |
| ALLOW COMPILATION OF THIS OPEN SOURCE LIBRARY WITHOUT HAVING |
| ORACLE PRODUCTS INSTALLED ON DEVELOPMENT ENVIRONMENTS |
| |
+----------------------------------------------------------------------+
*/
/* ------------------------------------------------------------------------ *
* $Id: oci_defs.h, v 3.2.0 2009/04/20 00:00 Vince $
* ------------------------------------------------------------------------ */
#ifndef OCILIB_OCI_DEFS_H_INCLUDED
#define OCILIB_OCI_DEFS_H_INCLUDED
#include "oci_types.h"
/*---------------------------------------------------------------------------
PUBLIC TYPES AND CONSTANTS
---------------------------------------------------------------------------*/
/* input data types */
#define SQLT_CHR 1 /* (ORANET TYPE) character string */
#define SQLT_NUM 2 /* (ORANET TYPE) oracle numeric */
#define SQLT_INT 3 /* (ORANET TYPE) integer */
#define SQLT_FLT 4 /* (ORANET TYPE) Floating point number */
#define SQLT_STR 5 /* zero terminated string */
#define SQLT_VNU 6 /* NUM with preceding length byte */
#define SQLT_PDN 7 /* (ORANET TYPE) Packed Decimal Numeric */
#define SQLT_LNG 8 /* long */
#define SQLT_VCS 9 /* Variable character string */
#define SQLT_NON 10 /* Null/empty PCC Descriptor entry */
#define SQLT_RID 11 /* rowid */
#define SQLT_DAT 12 /* date in oracle format */
#define SQLT_VBI 15 /* binary in VCS format */
#define SQLT_BFLOAT 21 /* Native Binary float*/
#define SQLT_BDOUBLE 22 /* NAtive binary double */
#define SQLT_BIN 23 /* binary data(DTYBIN) */
#define SQLT_LBI 24 /* long binary */
#define SQLT_UIN 68 /* unsigned integer */
#define SQLT_SLS 91 /* Display sign leading separate */
#define SQLT_LVC 94 /* Longer longs (char) */
#define SQLT_LVB 95 /* Longer long binary */
#define SQLT_AFC 96 /* Ansi fixed char */
#define SQLT_AVC 97 /* Ansi Var char */
#define SQLT_IBFLOAT 100 /* binary float canonical */
#define SQLT_IBDOUBLE 101 /* binary double canonical */
#define SQLT_CUR 102 /* cursor type */
#define SQLT_RDD 104 /* rowid descriptor */
#define SQLT_LAB 105 /* label type */
#define SQLT_OSL 106 /* oslabel type */
#define SQLT_NTY 108 /* named object type */
#define SQLT_REF 110 /* ref type */
#define SQLT_CLOB 112 /* character lob */
#define SQLT_BLOB 113 /* binary lob */
#define SQLT_BFILEE 114 /* binary file lob */
#define SQLT_CFILEE 115 /* character file lob */
#define SQLT_RSET 116 /* result set type */
#define SQLT_NCO 122 /* named collection type (varray or nested table) */
#define SQLT_VST 155 /* OCIString type */
#define SQLT_ODT 156 /* OCIDate type */
/* datetimes and intervals */
#define SQLT_DATE 184 /* ANSI Date */
#define SQLT_TIME 185 /* TIME */
#define SQLT_TIME_TZ 186 /* TIME WITH TIME ZONE */
#define SQLT_TIMESTAMP 187 /* TIMESTAMP */
#define SQLT_TIMESTAMP_TZ 188 /* TIMESTAMP WITH TIME ZONE */
#define SQLT_INTERVAL_YM 189 /* INTERVAL YEAR TO MONTH */
#define SQLT_INTERVAL_DS 190 /* INTERVAL DAY TO SECOND */
#define SQLT_TIMESTAMP_LTZ 232 /* TIMESTAMP WITH LOCAL TZ */
/* cxcheng: this has been added for backward compatibility -
it needs to be here because ocidfn.h can get included ahead of sqldef.h */
#define SQLT_FILE SQLT_BFILEE /* binary file lob */
#define SQLT_CFILE SQLT_CFILEE
#define SQLT_BFILE SQLT_BFILEE
#define SQLT_PNTY 241 /* pl/sql representation of named types */
/* CHAR/NCHAR/VARCHAR2/NVARCHAR2/CLOB/NCLOB char set "form" information */
#define SQLCS_IMPLICIT 1 /* for CHAR, VARCHAR2, CLOB w/o a specified set */
#define SQLCS_NCHAR 2 /* for NCHAR, NCHAR VARYING, NCLOB */
#define SQLCS_EXPLICIT 3 /* for CHAR, etc, with "CHARACTER SET ..." syntax */
#define SQLCS_FLEXIBLE 4 /* for PL/SQL "flexible" parameters */
#define SQLCS_LIT_NULL 5 /* for typecheck of NULL and empty_clob() lits */
/*-----------------------------Handle Types----------------------------------*/
/* handle types range from 1 - 49 */
#define OCI_HTYPE_FIRST 1 /* start value of handle type */
#define OCI_HTYPE_ENV 1 /* environment handle */
#define OCI_HTYPE_ERROR 2 /* error handle */
#define OCI_HTYPE_SVCCTX 3 /* service handle */
#define OCI_HTYPE_STMT 4 /* statement handle */
#define OCI_HTYPE_BIND 5 /* bind handle */
#define OCI_HTYPE_DEFINE 6 /* define handle */
#define OCI_HTYPE_DESCRIBE 7 /* describe handle */
#define OCI_HTYPE_SERVER 8 /* server handle */
#define OCI_HTYPE_SESSION 9 /* authentication handle */
#define OCI_HTYPE_AUTHINFO OCI_HTYPE_SESSION /* SessionGet auth handle */
#define OCI_HTYPE_DIRPATH_CTX 14 /* direct path context */
#define OCI_HTYPE_DIRPATH_COLUMN_ARRAY 15 /* direct path column array */
#define OCI_HTYPE_DIRPATH_STREAM 16 /* direct path stream */
#define OCI_HTYPE_TRANS 10 /* transaction handle */
#define OCI_HTYPE_CPOOL 26 /* connection pool handle */
/*-------------------------Descriptor Types----------------------------------*/
#define OCI_DTYPE_LOB 50 /* lob locator */
#define OCI_DTYPE_PARAM 53 /* a parameter descriptor obtained from ocigparm */
#define OCI_DTYPE_FILE 56 /* File Lob locator */
#define OCI_DTYPE_INTERVAL_YM 62 /* Interval year month */
#define OCI_DTYPE_INTERVAL_DS 63 /* Interval day second */
#define OCI_DTYPE_DATE 65 /* Date */
#define OCI_DTYPE_TIME 66 /* Time */
#define OCI_DTYPE_TIME_TZ 67 /* Time with timezone */
#define OCI_DTYPE_TIMESTAMP 68 /* Timestamp */
#define OCI_DTYPE_TIMESTAMP_TZ 69 /* Timestamp with timezone */
#define OCI_DTYPE_TIMESTAMP_LTZ 70 /* Timestamp with local tz */
#
/*---------------------------------------------------------------------------*/
/*--------------------------------LOB types ---------------------------------*/
#define OCI_TEMP_BLOB 1 /* LOB type - BLOB ------------------ */
#define OCI_TEMP_CLOB 2 /* LOB type - CLOB ------------------ */
/*---------------------------------------------------------------------------*/
/*--------------------------Attribute Types----------------------------------*/
#define OCI_ATTR_OBJECT 2 /* is the environment initialized in object mode */
#define OCI_ATTR_ENV 5 /* the environment handle */
#define OCI_ATTR_SERVER 6 /* the server handle */
#define OCI_ATTR_SESSION 7 /* the user session handle */
#define OCI_ATTR_TRANS 8 /* the transaction handle */
#define OCI_ATTR_ROW_COUNT 9 /* the rows processed so far */
#define OCI_ATTR_PREFETCH_ROWS 11 /* sets the number of rows to prefetch */
#define OCI_ATTR_NESTED_PREFETCH_ROWS 12 /* the prefetch rows of nested table*/
#define OCI_ATTR_PREFETCH_MEMORY 13 /* memory limit for rows fetched */
#define OCI_ATTR_NESTED_PREFETCH_MEMORY 14 /* memory limit for nested rows */
#define OCI_ATTR_PDSCL 16 /* packed decimal scale */
#define OCI_ATTR_FSPRECISION OCI_ATTR_PDSCL
/* fs prec for datetime data types */
#define OCI_ATTR_PDPRC 17 /* packed decimal format */
#define OCI_ATTR_LFPRECISION OCI_ATTR_PDPRC
/* fs prec for datetime data types */
#define OCI_ATTR_PARAM_COUNT 18 /* number of column in the select list */
#define OCI_ATTR_ROWID 19 /* the rowid */
#define OCI_ATTR_CHARSET 20 /* the character set value */
#define OCI_ATTR_USERNAME 22 /* username attribute */
#define OCI_ATTR_PASSWORD 23 /* password attribute */
#define OCI_ATTR_STMT_TYPE 24 /* statement type */
#define OCI_ATTR_XID 27 /* XOPEN defined global transaction id */
#define OCI_ATTR_CHARSET_ID 31 /* Character Set ID */
#define OCI_ATTR_CHARSET_FORM 32 /* Character Set Form */
#define OCI_ATTR_MAXDATA_SIZE 33 /* Maximumsize of data on the server */
#define OCI_ATTR_ROWS_RETURNED 42
/* Number of rows returned in current iter - for Bind handles */
#define OCI_ATTR_LOBEMPTY 45 /* empty lob ? */
#define OCI_ATTR_NUM_DML_ERRORS 73 /* num of errs in array DML */
#define OCI_ATTR_DML_ROW_OFFSET 74 /* row offset in the array */
#define OCI_ATTR_DATEFORMAT 75 /* default date format string */
#define OCI_ATTR_BUF_ADDR 76 /* buffer address */
#define OCI_ATTR_BUF_SIZE 77 /* buffer size */
#define OCI_ATTR_NUM_ROWS 81 /* number of rows in column array */
#define OCI_ATTR_COL_COUNT 82 /* columns of column array
processed so far. */
#define OCI_ATTR_NUM_COLS 102 /* number of columns */
#define OCI_ATTR_LIST_COLUMNS 103 /* parameter of the column list */
#define OCI_ATTR_PARAM 124 /* parameter descriptor */
#define OCI_ATTR_PARSE_ERROR_OFFSET 129 /* Parse Error offset */
#define OCI_ATTR_SERVER_STATUS 143 /* state of the server hdl */
#define OCI_ATTR_CURRENT_POSITION 164 /* for scrollable result sets*/
#define OCI_ATTR_CONN_NOWAIT 178
#define OCI_ATTR_CONN_BUSY_COUNT 179
#define OCI_ATTR_CONN_OPEN_COUNT 180
#define OCI_ATTR_CONN_TIMEOUT 181
#define OCI_ATTR_STMT_STATE 182
#define OCI_ATTR_CONN_MIN 183
#define OCI_ATTR_CONN_MAX 184
#define OCI_ATTR_CONN_INCR 185
#define OCI_ATTR_ROWS_FETCHED 197 /* rows fetched in last call */
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -