Class: OCIHandle

Inherits:

Object

• Object
• OCIHandle

Defined in:

lib/oci8/ocihandle.rb,
ext/oci8/stmt.c,
ext/oci8/encoding.c,
ext/oci8/ocihandle.c,
ext/oci8/connection_pool.c

Overview

– ocihandle.rb – Constants in OCIHandle.

Copyright © 2010 KUBO Takehiro <kubo@jiubao.org> ++

Direct Known Subclasses

OCI8, OCI8::ConnectionPool, OCI8::Cursor

Constant Summary

OCI_ATTR_DATA_SIZE =

maximum size of the data

1

OCI_ATTR_DATA_TYPE =

the SQL type of the column/argument

2

OCI_ATTR_NAME =

the name of the column/argument

4

OCI_ATTR_PRECISION =

precision if number type

5

OCI_ATTR_SCALE =

scale if number type

6

OCI_ATTR_IS_NULL =

is it null ?

7

OCI_ATTR_TYPE_NAME =

name of the named data type or a package name

8

OCI_ATTR_SCHEMA_NAME =

the schema name

9

OCI_ATTR_SUB_NAME =

type name if package private type

10

OCI_ATTR_POSITION =

relative position

11

OCI_ATTR_PDSCL =

packed decimal scale

16

OCI_ATTR_FSPRECISION =

fs prec for datetime data types

OCI_ATTR_PDSCL

OCI_ATTR_PDPRC =

packed decimal format

17

OCI_ATTR_LFPRECISION =

fs prec for datetime data types

OCI_ATTR_PDPRC

OCI_ATTR_USERNAME =

username attribute

22

OCI_ATTR_PASSWORD =

password attribute

23

OCI_ATTR_CHARSET_ID =

Character Set ID

31

OCI_ATTR_CHARSET_FORM =

Character Set Form

32

OCI_ATTR_NUM_COLS =

number of columns

102

OCI_ATTR_LIST_COLUMNS =

parameter of the column list

103

OCI_ATTR_RDBA =

DBA of the segment header

104

OCI_ATTR_CLUSTERED =

whether the table is clustered

105

OCI_ATTR_PARTITIONED =

whether the table is partitioned

106

OCI_ATTR_INDEX_ONLY =

whether the table is index only

107

OCI_ATTR_LIST_ARGUMENTS =

parameter of the argument list

108

OCI_ATTR_LIST_SUBPROGRAMS =

parameter of the subprogram list

109

OCI_ATTR_REF_TDO =

REF to the type descriptor

110

OCI_ATTR_LINK =

the database link name

111

OCI_ATTR_MIN =

minimum value

112

OCI_ATTR_MAX =

maximum value

113

OCI_ATTR_INCR =

increment value

114

OCI_ATTR_CACHE =

number of sequence numbers cached

115

OCI_ATTR_ORDER =

whether the sequence is ordered

116

OCI_ATTR_HW_MARK =

high-water mark

117

OCI_ATTR_TYPE_SCHEMA =

type’s schema name

118

OCI_ATTR_TIMESTAMP =

timestamp of the object

119

OCI_ATTR_NUM_PARAMS =

number of parameters

121

OCI_ATTR_OBJID =

object id for a table or view

122

OCI_ATTR_OVERLOAD_ID =

overload ID for funcs and procs

125

OCI_ATTR_TABLESPACE =

table name space

126

OCI_ATTR_LTYPE =

list type

128

OCI_ATTR_IS_TEMPORARY =

whether table is temporary

130

OCI_ATTR_IS_TYPED =

whether table is typed

131

OCI_ATTR_DURATION =

duration of temporary table

132

OCI_ATTR_IS_INVOKER_RIGHTS =

is invoker rights

133

OCI_ATTR_OBJ_NAME =

top level schema obj name

134

OCI_ATTR_OBJ_SCHEMA =

schema name

135

OCI_ATTR_OBJ_ID =

top level schema object id

136

OCI_ATTR_CONN_NOWAIT =

178

OCI_ATTR_CONN_BUSY_COUNT =

179

OCI_ATTR_CONN_OPEN_COUNT =

180

OCI_ATTR_CONN_TIMEOUT =

181

OCI_ATTR_CONN_MIN =

183

OCI_ATTR_CONN_MAX =

184

OCI_ATTR_CONN_INCR =

185

OCI_ATTR_OVERLOAD =

is this position overloaded

210

OCI_ATTR_LEVEL =

level for structured types

211

OCI_ATTR_HAS_DEFAULT =

has a default value

212

OCI_ATTR_IOMODE =

in, out inout

213

OCI_ATTR_RADIX =

returns a radix

214

OCI_ATTR_NUM_ARGS =

total number of arguments

215

OCI_ATTR_TYPECODE =

object or collection

216

OCI_ATTR_COLLECTION_TYPECODE =

varray or nested table

217

OCI_ATTR_VERSION =

user assigned version

218

OCI_ATTR_IS_INCOMPLETE_TYPE =

is this an incomplete type

219

OCI_ATTR_IS_SYSTEM_TYPE =

a system type

220

OCI_ATTR_IS_PREDEFINED_TYPE =

a predefined type

221

OCI_ATTR_IS_TRANSIENT_TYPE =

a transient type

222

OCI_ATTR_IS_SYSTEM_GENERATED_TYPE =

system generated type

223

OCI_ATTR_HAS_NESTED_TABLE =

contains nested table attr

224

OCI_ATTR_HAS_LOB =

has a lob attribute

225

OCI_ATTR_HAS_FILE =

has a file attribute

226

OCI_ATTR_COLLECTION_ELEMENT =

has a collection attribute

227

OCI_ATTR_NUM_TYPE_ATTRS =

number of attribute types

228

OCI_ATTR_LIST_TYPE_ATTRS =

list of type attributes

229

OCI_ATTR_NUM_TYPE_METHODS =

number of type methods

230

OCI_ATTR_LIST_TYPE_METHODS =

list of type methods

231

OCI_ATTR_MAP_METHOD =

map method of type

232

OCI_ATTR_ORDER_METHOD =

order method of type

233

OCI_ATTR_NUM_ELEMS =

number of elements

234

OCI_ATTR_ENCAPSULATION =

encapsulation level

235

OCI_ATTR_IS_SELFISH =

method selfish

236

OCI_ATTR_IS_VIRTUAL =

virtual

237

OCI_ATTR_IS_INLINE =

inline

238

OCI_ATTR_IS_CONSTANT =

constant

239

OCI_ATTR_HAS_RESULT =

has result

240

OCI_ATTR_IS_CONSTRUCTOR =

constructor

241

OCI_ATTR_IS_DESTRUCTOR =

destructor

242

OCI_ATTR_IS_OPERATOR =

operator

243

OCI_ATTR_IS_MAP =

a map method

244

OCI_ATTR_IS_ORDER =

order method

245

OCI_ATTR_IS_RNDS =

read no data state method

246

OCI_ATTR_IS_RNPS =

read no process state

247

OCI_ATTR_IS_WNDS =

write no data state method

248

OCI_ATTR_IS_WNPS =

write no process state

249

OCI_ATTR_IS_SUBTYPE =

258

OCI_ATTR_SUPERTYPE_SCHEMA_NAME =

259

OCI_ATTR_SUPERTYPE_NAME =

260

OCI_ATTR_LIST_OBJECTS =

list of objects in schema

261

OCI_ATTR_NCHARSET_ID =

char set id

262

OCI_ATTR_LIST_SCHEMAS =

list of schemas

263

OCI_ATTR_MAX_PROC_LEN =

max procedure length

264

OCI_ATTR_MAX_COLUMN_LEN =

max column name length

265

OCI_ATTR_CURSOR_COMMIT_BEHAVIOR =

cursor commit behavior

266

OCI_ATTR_MAX_CATALOG_NAMELEN =

catalog namelength

267

OCI_ATTR_CATALOG_LOCATION =

catalog location

268

OCI_ATTR_SAVEPOINT_SUPPORT =

savepoint support

269

OCI_ATTR_NOWAIT_SUPPORT =

nowait support

270

OCI_ATTR_AUTOCOMMIT_DDL =

autocommit DDL

271

OCI_ATTR_LOCKING_MODE =

locking mode

272

OCI_ATTR_CLIENT_IDENTIFIER =

value of client id to set

278

OCI_ATTR_IS_FINAL_TYPE =

is final type ?

279

OCI_ATTR_IS_INSTANTIABLE_TYPE =

is instantiable type ?

280

OCI_ATTR_IS_FINAL_METHOD =

is final method ?

281

OCI_ATTR_IS_INSTANTIABLE_METHOD =

is instantiable method ?

282

OCI_ATTR_IS_OVERRIDING_METHOD =

is overriding method ?

283

OCI_ATTR_DESC_SYNBASE =

Describe the base object

284

OCI_ATTR_CHAR_USED =

char length semantics

285

OCI_ATTR_CHAR_SIZE =

char length

286

OCI_ATTR_CONDITION =

rule condition

342

OCI_ATTR_COMMENT =

comment

343

OCI_ATTR_VALUE =

Anydata value

344

OCI_ATTR_EVAL_CONTEXT_OWNER =

eval context owner

345

OCI_ATTR_EVAL_CONTEXT_NAME =

eval context name

346

OCI_ATTR_EVALUATION_FUNCTION =

eval function name

347

OCI_ATTR_VAR_TYPE =

variable type

348

OCI_ATTR_VAR_VALUE_FUNCTION =

variable value function

349

OCI_ATTR_VAR_METHOD_FUNCTION =

variable method function

350

OCI_ATTR_ACTION_CONTEXT =

action context

351

OCI_ATTR_LIST_TABLE_ALIASES =

list of table aliases

352

OCI_ATTR_LIST_VARIABLE_TYPES =

list of variable types

353

OCI_ATTR_TABLE_NAME =

table name

356

OCI_DEFAULT =

the default value for parameters and attributes

0

OCI_CRED_RDBMS =

database username/password credentials

1

OCI_CRED_EXT =

externally provided credentials

2

OCI_SYSDBA =

for SYSDBA authorization

0x0002

OCI_SYSOPER =

for SYSOPER authorization

0x0004

OCI_CPOOL =

Attach using server handle from pool

0x0200

OCI_PTYPE_UNK =

parameter type for unknown type

0

OCI_PTYPE_TABLE =

parameter type for table

1

OCI_PTYPE_VIEW =

parameter type for view

2

OCI_PTYPE_PROC =

parameter type for procedure

3

OCI_PTYPE_FUNC =

parameter type for function

4

OCI_PTYPE_PKG =

parameter type for package

5

OCI_PTYPE_TYPE =

parameter type for user-defined type

6

OCI_PTYPE_SYN =

parameter type for synonym

7

OCI_PTYPE_SEQ =

parameter type for sequence

8

OCI_PTYPE_COL =

parameter type for column

9

OCI_PTYPE_ARG =

parameter type for argument

10

OCI_PTYPE_LIST =

parameter type for list

11

OCI_PTYPE_TYPE_ATTR =

parameter type for user-defined type’s attribute

12

OCI_PTYPE_TYPE_COLL =

parameter type for collection type’s element

13

OCI_PTYPE_TYPE_METHOD =

parameter type for user-defined type’s method

14

OCI_PTYPE_TYPE_ARG =

parameter type for user-defined type method’s arg

15

OCI_PTYPE_TYPE_RESULT =

parameter type for user-defined type method’s result

16

OCI_PTYPE_SCHEMA =

parameter type for schema

17

OCI_PTYPE_DATABASE =

parameter type for database

18

OCI_PTYPE_RULE =

parameter type for rule

19

OCI_PTYPE_RULE_SET =

parameter type for rule set

20

OCI_PTYPE_EVALUATION_CONTEXT =

parameter type for evaluation context

21

OCI_PTYPE_TABLE_ALIAS =

parameter type for table alias

22

OCI_PTYPE_VARIABLE_TYPE =

parameter type for variable type

23

OCI_PTYPE_NAME_VALUE =

parameter type for name value pair

24

OCI_LTYPE_UNK =

list type for unknown type

0

OCI_LTYPE_COLUMN =

list type for column list

1

OCI_LTYPE_ARG_PROC =

list type for procedure argument list

2

OCI_LTYPE_ARG_FUNC =

list type for function argument list

3

OCI_LTYPE_SUBPRG =

list type for subprogram list

4

OCI_LTYPE_TYPE_ATTR =

list type for type attribute

5

OCI_LTYPE_TYPE_METHOD =

list type for type method

6

OCI_LTYPE_TYPE_ARG_PROC =

list type for type method w/o result argument list

7

OCI_LTYPE_TYPE_ARG_FUNC =

list type for type method w/result argument list

8

OCI_LTYPE_SCH_OBJ =

list type for schema object list

9

OCI_LTYPE_DB_SCH =

list type for database schema list

10

OCI_LTYPE_TYPE_SUBTYPE =

list type for subtype list

11

OCI_LTYPE_TABLE_ALIAS =

list type for table alias list

12

OCI_LTYPE_VARIABLE_TYPE =

list type for variable type list

13

OCI_LTYPE_NAME_VALUE =

list type for name value list

14

OCI_DURATION_INVALID =

0xFFFF

OCI_DURATION_BEGIN =

10

OCI_DURATION_NULL =

OCI_DURATION_BEGIN - 1

OCI_DURATION_DEFAULT =

OCI_DURATION_BEGIN - 2

OCI_DURATION_USER_CALLBACK =

OCI_DURATION_BEGIN - 3

OCI_DURATION_NEXT =

OCI_DURATION_BEGIN - 4

OCI_DURATION_SESSION =

OCI_DURATION_BEGIN

OCI_DURATION_TRANS =

OCI_DURATION_BEGIN + 1

OCI_DURATION_CALL =

OCI_DURATION_BEGIN + 2

OCI_DURATION_STATEMENT =

OCI_DURATION_BEGIN + 3

OCI_DURATION_CALLOUT =

OCI_DURATION_BEGIN + 4