Oracle Data Provider for .NET Developer's Guide -- Index

array bind feature, 3-21

array binding, 3-21

ArrayBindSize property, 3-22

ArrayBindStatus property, 3-22

assembly, 1-2

Behavior of ExecuteScalar Method for REF CURSOR, 3-26

BFILE, 3-26

binding, 3-15

BLOB, 3-26

C#, 4-3

callback support, 3-7

Class Inheritance, 4-2

client globalization settings, 3-30, 3-33

CLOB, 3-26

Connection Lifetime, 3-3

connection pooling, 3-3

connection pooling example, 3-4

Connection property, 3-28

connection string attributes, 3-2, 4-56

Connection Timeout, 3-3

ConnectionString, 3-3

ConnectionString attributes, 3-3

Connection Lifetime, 3-3

Connection Timeout, 3-3

Decr Pool Size, 3-3

Incr Pool Size, 3-3

Max Pool Size, 3-3

Min Pool Size, 3-3

Pooling, 3-3

controlling query reexecution, 3-38

controlling the number of rows fetched in one server round-trip, 3-14

data loss, 3-35

DataSet, 3-28

updating, 3-25

DbType

inference, 3-17

Debug Tracing, 3-38

registry settings, 3-39

Decr Pool Size, 3-3

documentation, 2-2

example

connection pooling, 3-4

ExecuteNonQuery, 3-25

ExecuteScalar method, 3-26

FailoverEvent Enumeration, 4-333

FailoverReturnCode Enumeration, 4-334

FailoverType Enumeration, 4-335

features, 3-1

Global Assembly Cache (GAC), 2-2

globalization settings, 3-30

globalization support, 3-30

globalization-sensitive operations, 3-33

Incr Pool Size, 3-3

inference from Value property, 3-20

Inference of DbType and OracleDbType from Value, 3-20

Inference of DbType from OracleDbType, 3-18

Inference of OraDbType from DbType, 3-19

inference of types, 3-17

InitialLONGFetchSize, 3-13

installation, 2-2

Oracle COM Automation, 2-2

Interface Inheritance, 4-2

interference in OracleParameter class, 3-17

introduction, overview, 1-2

InvalidCastException, 3-11

large binary datatypes, 3-26

large character datatypes, 3-26

LOB Connection property, 3-28

LOBs

temporary, 3-29

updating, 3-28, 3-29

LOBs updating, 3-28

LONG and LONG RAW datatypes, 3-26

Max Pool Size, 3-3

Microsoft Transaction Server, 2-2

Min Pool Size, 3-3

MTS, 2-2

NCLOB, 3-26

.NET Framework datatype, 3-9

.NET type accessors, 3-11

.NET Types

inference, 3-17

obtaining a REF CURSOR, 3-24

Obtaining an OracleRefCursor, 3-24

Obtaining Data From an OracleDataReader, 3-10

obtaining LONG and LONG RAW Data, 3-13

ODP.NET LOB classes, 3-26

ODP.NET Type accessors, 3-12

ODP.NET Type classes, 3-9

ODP.NET Type Exceptions, 5-497

ODP.NET Type Structures, 5-3

ODP.NET Type structures, 3-9

ODP.NET Types, 3-9

ODP.NET Types Overview, 3-9

Oracle COM Automation

installing, 2-2

Oracle Data Provider for .NET

system requirements, 2-2

Oracle native types, 3-9

supported by ODP.NET, 3-11

Oracle Net Services, 2-2

Oracle Services for Microsoft Transaction Server, 2-2

Oracle Universal Installer (OUI), 2-2

ORACLE_BASEORACLE_HOMEbin directory, 2-2

Oracle9i Client, 2-2

OracleBFile

constructors, 5-524

instance methods, 5-535

instance properties, 5-527

members, 5-521

static fields, 5-526

static methods, 5-527

OracleBFile Class, 5-519

OracleBinary

constructor, 5-9

instance methods, 5-27

members, 5-6

properties, 5-24

static fields, 5-9

static methods, 5-10

static operators, 5-16

static type conversion operators, 5-23

OracleBinary Structure, 5-4

OracleBlob

constructors, 5-562

instance methods, 5-572

instance properties, 5-565

members, 5-558

static fields, 5-564

static methods, 5-564

OracleBlob Class, 5-556

OracleClob

constructors, 5-600

instance methods, 5-610

instance properties, 5-603

members, 5-596

static fields, 5-602

static methods, 5-603

OracleClob Class, 5-594

OracleCommand

constructors, 4-10

members, 4-7

properties, 4-12

public methods, 4-22

static methods, 4-12

OracleCommand ArrayBindCount property, 3-21

OracleCommand Class, 4-5

OracleCommand FetchSize property, 3-14

OracleCommand object, 3-15

OracleCommand Transaction object, 3-15

OracleCommandBuilder

constructors, 4-37

event delegates, 4-44

events, 4-43

members, 4-34

properties, 4-38

public methods, 4-40

static methods, 4-38

OracleCommandBuilder Class, 4-31

OracleConnection

constructors, 4-51

event delegates, 4-77

events, 4-74

members, 4-47

properties, 4-53

public methods, 4-63

static methods, 4-53

OracleConnection Class, 4-45

Oracle.DataAccess.Client, 4-2

Oracle.DataAccesss.dll assembly, 2-2

OracleDataAdapter, 3-35

constructors, 4-85

event delegates, 4-105

events, 4-100

members, 4-82

properties, 4-88

public methods, 4-95

Requery property, 3-38

SafeMapping Property, 3-37

static methods, 4-88

OracleDataAdapter Class, 4-79

OracleDataAdapter Safe Type Mapping, 3-35

OracleDataReader, 3-10

members, 4-111

properties, 4-115

public methods, 4-122

static methods, 4-115

OracleDataReader Class, 4-107

OracleDataReader FetchSize property, 3-14

OracleDataReader SchemaTable, 4-163

OracleDate

constructors, 5-38

members, 5-34

methods, 5-67

properties, 5-62

static fields, 5-43

static methods, 5-44

static operators, 5-52

static type conversions, 5-58

OracleDate Structure, 5-32

OracleDbType

inference, 3-17

OracleDbType Enumeration Type, 4-336

OracleDbType enumeration type, 3-16

OracleDbType enumeration values, 3-17

OracleDecimal

constructors, 5-84

instance methods, 5-157

members, 5-76

properties, 5-152

static comparison methods, 5-95

static comparison operators, 5-132

static logarithmic methods, 5-118

static manipulation methods, 5-101

static operators .NET Type to OracleDecimal, 5-142

static operators, OracleDecimal to .NET, 5-146

static trignonmetric methods, 5-124

OracleDecimal Structure, 5-74

OracleError

members, 4-174

methods, 4-179

properties, 4-176

static methods, 4-176

OracleError Class, 4-172

OracleErrorCollection

members, 4-183

properties, 4-185

public methods, 4-185

static methods, 4-185

OracleErrorCollection Class, 4-181

OracleException

members, 4-189

methods, 4-195

properties, 4-191

static methods, 4-191

OracleException Class, 4-187

OracleFailoverEventArgs

members, 4-200

properties, 4-201

public methods, 4-202

OracleFailoverEventHandler Delegate, 4-204

OracleGlobalization

members, 4-209

properties, 4-217

public methods, 4-230

static methods, 4-211

OracleInfoMessageEventArgs

members, 4-234

properties, 4-236

public methods, 4-238

static methods, 4-236

OracleInfoMessageEventHandler Delegate, 4-239

OracleIntervalDS

constructors, 5-171

members, 5-167

methods, 5-205

properties, 5-199

static methods, 5-179

static operators, 5-187

type conversions, 5-197

OracleIntervalDS Structure, 5-165

OracleIntervalYM

constructors, 5-216

members, 5-212

methods, 5-222, 5-246

properties, 5-242

static fields, 5-220

static operators, 5-230

type conversions, 5-239

OracleIntervalYM Structure, 5-210

OracleNullValueException

constructors, 5-509

members, 5-507

methods, 5-510, 5-511

properties, 5-510

OracleNullValueException Class, 5-506

OracleParameter

constructors, 4-245

inferences of types, 3-17

members, 4-242

properties, 4-259

public methods, 4-272

static methods, 4-258

OracleParameter array bind feature, 3-21

OracleParameter array bind properties, 3-22

OracleParameter Class, 4-240

OracleParameter class

Value, 3-20

OracleParameterCollection

members, 4-277

public methods, 4-282

static methods, 4-279

OracleParameterCollection Class, 4-275

OracleParameterStatus enumeration type, 3-23, 4-338

OracleRefCursor, 3-23

instance methods, 5-645

members, 5-642

properties, 5-644

static methods, 5-644

OracleRefCursor Class, 5-640

OracleRowUpdatedEventArgs

constructor, 4-308

members, 4-306

properties, 4-309

public methods, 4-310

static methods, 4-308

OracleRowUpdatedEventArgs Class, 4-304

OracleRowUpdatedEventHandler Delegate, 4-303

OracleRowUpdatingEventArgs

constructor, 4-315

members, 4-313

properties, 4-316

public methods, 4-317

static methods, 4-315

OracleRowUpdatingEventArgs Class, 4-311

OracleRowUpdatingEventHandler Delegate, 4-318

OracleString

constructors, 5-256

members, 5-252

methods, 5-279

properties, 5-276

static fields, 5-261

static methods, 5-262

static operators, 5-269

type conversions, 5-275

OracleString Structure, 5-250

OracleTimeStamp

constructors, 5-294

members, 5-288

methods, 5-337

properties, 5-330

static methods, 5-303

static operators, 5-312

static type conversions, 5-324

OracleTimeStamp Structure, 5-286

OracleTimeStampLTZ

constructors, 5-360

members, 5-354

methods, 5-405

properties, 5-398

static fields, 5-368

static methods, 5-370

static type conversions, 5-392

static type operators, 5-380

OracleTimeStampLTZ Structure, 5-352

OracleTimeStampTZ

constructors, 5-428

members, 5-422

methods, 5-480

properties, 5-473

static fields, 5-443

static methods, 5-445

static operators, 5-454

static type conversions, 5-465

OracleTimeStampTZ Structure, 5-420

OracleTransaction

members, 4-321

properties, 4-323

public methods, 4-325

static methods, 4-323

OracleTruncateException

constructors, 5-515

members, 5-513

methods, 5-517

properties, 5-516

static methods, 5-516

OracleTruncateException Class, 5-512

OracleTypeException

constructors, 5-501

members, 5-499

properties, 5-502

static methods, 5-502

OracleTypeException Class, 5-498

OS Authentication, 3-5

OS authentication, 4-59

Overview of ODP.NET Types, 5-2

Overview of Oracle Data Provider Classes, 4-2

parameter binding, 3-15

password expiration, 3-6

PL/SQL language, 3-23

PL/SQL REF CURSOR, 3-23

PL/SQL REF CURSOR and OracleRefCursor, 3-23

Pooling, 3-3

populating an OracleDataReader from a REF CURSOR, 3-24

populating an OracleRefCursor from a REF CURSOR, 3-25

populating the DataSet from a REF CURSOR, 3-25

preventing data loss, 3-35, 3-37

privileged connections, 3-5

proxy authentication, 3-7

readme.txt, 2-2

Requery property, 3-38

round-trip, 3-21

Safe Type Mapping, 3-35

SafeMapping Property, 3-37

Samples, 1-6, 2-2

SchemaTable, 4-163

select list, 3-14

session globalization parameters, 3-34

session globalization settings, 3-31

Stream class, 3-27

Syntax Used

described, 4-3

system requirements, 2-2

Oracle Data Provider for .NET, 2-2

TAF, 3-7

TAF callback support, 3-7

Temporary LOBs, 3-29

thread globalization settings, 3-33

thread-based globalization settings, 3-32

TraceFileName, 3-39

TraceLevel, 3-39

TraceOption, 3-39

Transaction object, 3-15

Transparent Application Failover (TAF), 3-7

Typed OracleDataReader Accessors, 3-10

updating

LOBs, 3-28

updating a DataSet Obtained from a REF CURSOR, 3-25

updating LOBs using a DataSet, 3-28

updating LOBs using ODP.NET LOB objects, 3-29

updating LOBs using OracleCommand and OracleParameter, 3-28

using OracleCommand FetchSize property, 3-14

using OracleDataReader FetchSize property, 3-14