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

array bind feature, 3-28

Array Bind operations

ArrayBindCount, 4-15

ArrayBindIndex, 4-191

ArrayBindSize, 4-274

ArrayBindStatus, 4-275

Array Binding

error handling, 3-29

array binding, 3-28

ArrayBindCount property, 4-15

ArrayBindIndex, 4-191

ArrayBindSize, 4-274

ArrayBindSize property, 3-25, 3-29

ArrayBindStatus, 4-275

ArrayBindStatus property, 3-25, 3-29

assembly, 1-2

behavior of ExecuteScalar method for REF CURSOR, 3-33

BFILE, 3-33

binding, 3-18

PL/SQL Associative Array, 3-25

BLOB, 3-33

C#, 4-3

callback support, 3-7

case-sensitivity

column name mapping, 3-63

Class Inheritance, 4-2

client globalization settings, 3-38, 3-40

CLOB, 3-33

CollectionType property, 3-25

column data

special characters in, 3-62

commits

changes to XML data, 3-67

connection dependency, 3-52

Connection Lifetime, 3-3

connection pooling, 3-3

connection pooling example, 3-4

Connection property, 3-35

connection string attributes, 4-65

Connection Timeout, 3-3

ConnectionString, 3-3

ConnectionString attributes, 3-3

Connection Lifetime, 3-2

Connection Timeout, 3-2

Decr Pool Size, 3-2

Incr Pool Size, 3-2

Max Pool Size, 3-2

Min Pool Size, 3-2

Pooling, 3-2

Constraints property, 3-41

configuring, 3-42

controlling query reexecution, 3-47

data loss, 3-44

data manipulation

using XML, 3-61

database

changes to, 3-61

DataSet, 3-35

updating, 3-33

dataset

updating to database, 3-41

DataTable, 3-42

Datatable properties, 3-41

DbType

inference, 3-21

debug tracing, 3-48

registry settings, 3-48

Decr Pool Size, 3-3

default mapping

improving, 3-66

documentation, 2-3

error handling

Array Binding, 3-29

example

connection pooling, 3-4

ExecuteNonQuery, 3-32

ExecuteScalar method, 3-33

FailoverEvent Enumeration, 4-372

FailoverReturnCode Enumeration, 4-373

FailoverType Enumeration, 4-374

features, 3-1

FetchSize property

fine-tuning, 3-17

setting at design time, 3-17

setting at runtime, 3-18

using, 3-16

Fill, 3-32

Global Assembly Cache (GAC), 2-3

globalization settings, 3-37

client, 3-38

session, 3-38

thread-based, 3-39

globalization support, 3-37

globalization-sensitive operations, 3-40

Handling Date and Time Format

manipulating data in XML, 3-61

retrieving queries in XML, 3-56

improving default mapping, 3-66

Incr Pool Size, 3-3

inference from Value property, 3-23

Inference of DbType and OracleDbType from Value, 3-23

Inference of DbType from OracleDbType, 3-21

Inference of OracleDbType from DbType, 3-22

inference of types, 3-21

InitialLOBFetchSize, 3-15

InitialLONGFetchSize, 3-14

input binding

XMLType column, 3-53

installation, 2-3

Oracle Data Provider for .NET, 2-3

Interface Inheritance, 4-2

interference in OracleParameter class, 3-21

introduction, overview, 1-2

InvalidCastException, 3-11

large binary datatypes, 3-34

large character datatypes, 3-33

LOB Connection property, 3-35

LOBs

temporary, 3-37

updating, 3-36

LOBs updating, 3-35

LONG and LONG RAW datatypes, 3-34

Max Pool Size, 3-3

metadata, 3-44

Microsoft Transaction Server, 2-2

Min Pool Size, 3-3

MTS, 2-2

multiple tables

changes to, 3-66

native XML support, 3-50

NCLOB, 3-33

.NET Framework datatype, 3-9

.NET Stream class, 3-34

.NET type accessors, 3-11

.NET Types

inference, 3-21

NULL values

retrieving from column, 3-61

number of rows fetched in round-trip

controlling, 3-16

object-relational data, 3-60

saving changes from XML data, 3-66

obtaining a REF CURSOR, 3-31

Obtaining an OracleRefCursor, 3-31

Obtaining Data From an OracleDataReader, 3-11

Obtaining LOB data

InitialLOBFetchSize, 3-15

obtaining LONG and LONG RAW Data, 3-14

ODP.NET

installing, 2-3

ODP.NET LOB classes, 3-33

ODP.NET Type accessors, 3-13

ODP.NET Type classes, 3-9

ODP.NET Type Exceptions, 5-495

ODP.NET Type Structures, 5-3

ODP.NET Type structures, 3-9

ODP.NET Types, 3-9

ODP.NET Types Overview, 3-9

ODP.NET XML Support, 3-50

operating system authentication, 3-5

Oracle 8.1.7, 3-50

saving changes to, 3-64

Oracle Data Provider for .NET

installing, 2-3

system requirements, 2-2

Oracle native types, 3-9

supported by ODP.NET, 3-11

Oracle Services for Microsoft Transaction Server, 2-2

Oracle Universal Installer (OUI), 2-3

Oracle XDK, 3-50

ORACLE_BASEORACLE_HOMEbin directory, 2-3

Oracle9i

saving changes to, 3-65

Oracle9i Client, 2-2

Oracle9i XML Developer's Kit, 3-50

OracleBFile

constructors, 5-522

instance methods, 5-533

instance properties, 5-525

members, 5-519

static fields, 5-524

static methods, 5-525

OracleBFile Class, 5-517

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-559

instance methods, 5-568

instance properties, 5-562

members, 5-555

static fields, 5-561

static methods, 5-561

OracleBlob Class, 5-553

OracleClob

constructors, 5-597

instance methods, 5-607

instance properties, 5-600

members, 5-593

static fields, 5-599

static methods, 5-600

OracleClob Class, 5-591

OracleCollectionType Enumeration, 4-375

OracleCommand

ArrayBindCount, 4-15

constructors, 4-11

FetchSize property, 3-16

members, 4-8

properties, 4-13

public methods, 4-29

static methods, 4-13

OracleCommand ArrayBindCount property, 3-28

OracleCommand Class, 4-5

OracleCommand object, 3-18

OracleCommand Transaction object, 3-18

OracleCommandBuilder, 3-44

constructors, 4-48

event delegates, 4-55

events, 4-54

members, 4-45

properties, 4-49

public methods, 4-51

static methods, 4-49

updating dataset, 3-41

OracleCommandBuilder Class, 4-42

OracleConnection

constructors, 4-61

event delegates, 4-87

events, 4-84

members, 4-58

obtaining a reference, 3-52

properties, 4-63

public methods, 4-73

static methods, 4-63

OracleConnection Class, 4-56

Oracle.DataAccess.Client, 4-2

Oracle.DataAccess.dll assembly, 2-3

OracleDataAdapter, 3-44

constructors, 4-95

event delegates, 4-115

events, 4-111

FillSchema, 3-42, 3-44

members, 4-92

properties, 4-98

public methods, 4-105

Requery property, 3-47

SafeMapping Property, 3-46

SelectCommand, 3-42, 3-44

static methods, 4-98

OracleDataAdapter Class, 4-89

OracleDataAdapter Safe Type Mapping, 3-44

OracleDataReader, 3-11

members, 4-121

properties, 4-125

public methods, 4-133

static methods, 4-125

OracleDataReader Class, 4-117

OracleDataReader SchemaTable, 4-173

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-21

OracleDbType Enumeration Type, 4-376

OracleDbType enumeration type, 3-19

OracleDbType enumeration values, 3-21

OracleDecimal

constructors, 5-83

instance methods, 5-156

members, 5-76

properties, 5-151

static comparison methods, 5-94

static comparison operators, 5-131

static logarithmic methods, 5-117

static manipulation methods, 5-100

static operators, .NET Type to OracleDecimal, 5-141

static operators, OracleDecimal to .NET, 5-145

static trignonmetric methods, 5-123

OracleDecimal Structure, 5-74

OracleError

ArrayBindIndex, 4-191

members, 4-188

methods, 4-194

properties, 4-190

static methods, 4-190

OracleError Class, 4-186

OracleErrorCollection

members, 4-198

properties, 4-200

public methods, 4-200

static methods, 4-200

OracleErrorCollection Class, 4-196

OracleException

members, 4-204

methods, 4-210

properties, 4-206

static methods, 4-206

OracleException Class, 4-202

OracleFailoverEventArgs

members, 4-215

properties, 4-216

public methods, 4-217

OracleFailoverEventHandler Delegate, 4-219

OracleGlobalization

members, 4-224

properties, 4-232

public methods, 4-244

static methods, 4-226

OracleInfoMessageEventArgs

members, 4-249

properties, 4-250

public methods, 4-252

static methods, 4-250

OracleInfoMessageEventHandler Delegate, 4-253

OracleIntervalDS

constructors, 5-170

members, 5-166

methods, 5-204

properties, 5-199

static methods, 5-178

static operators, 5-186

type conversions, 5-196

OracleIntervalDS Structure, 5-164

OracleIntervalYM

constructors, 5-215

members, 5-211

methods, 5-221, 5-245

properties, 5-241

static fields, 5-219

static operators, 5-229

type conversions, 5-238

OracleIntervalYM Structure, 5-209

OracleNullValueException

constructors, 5-507

members, 5-505

methods, 5-508, 5-509

properties, 5-508

OracleNullValueException Class, 5-504

OracleParameter

ArrayBindSize, 4-274

ArrayBindStatus, 4-275

constructors, 4-259

inferences of types, 3-21

members, 4-256

properties, 4-273

public methods, 4-289

static methods, 4-272

OracleParameter array bind feature, 3-28

OracleParameter array bind properties, 3-29

OracleParameter Class, 4-254

OracleParameter class

Value, 3-23

OracleParameter property

ArrayBindSize, 3-25

ArrayBindStatus, 3-25

CollectionType, 3-25

Size, 3-25

Value, 3-25

OracleParameterCollection

members, 4-294

public methods, 4-299

static methods, 4-296

OracleParameterCollection Class, 4-292

OracleParameterStatus enumeration type, 3-30, 4-378

OracleReader

FetchSize property, 3-16

OracleRefCursor, 3-31

instance methods, 5-641

members, 5-638

populating, 3-32

properties, 5-640

static methods, 5-640

OracleRefCursor Class, 5-636

OracleRowUpdatedEventArgs

constructor, 4-325

members, 4-323

properties, 4-326

public methods, 4-327

static methods, 4-325

OracleRowUpdatedEventArgs Class, 4-321

OracleRowUpdatedEventHandler Delegate, 4-320

OracleRowUpdatingEventArgs

constructor, 4-332

members, 4-330

properties, 4-333

public methods, 4-334

static methods, 4-332

OracleRowUpdatingEventArgs Class, 4-328

OracleRowUpdatingEventHandler Delegate, 4-335

OracleString

constructors, 5-255

members, 5-251

methods, 5-279

properties, 5-276

static fields, 5-260

static methods, 5-261

static operators, 5-268

type conversions, 5-274

OracleString Structure, 5-249

OracleTimeStamp

constructors, 5-293

members, 5-287

methods, 5-336

properties, 5-329

static methods, 5-302

static operators, 5-311

static type conversions, 5-323

OracleTimeStamp Structure, 5-285

OracleTimeStampLTZ

constructors, 5-359

members, 5-353

methods, 5-403

properties, 5-397

static fields, 5-367

static methods, 5-369

static type conversions, 5-390

static type operators, 5-379

OracleTimeStampLTZ Structure, 5-351

OracleTimeStampTZ

constructors, 5-427

members, 5-421

methods, 5-479

properties, 5-472

static fields, 5-442

static methods, 5-444

static operators, 5-453

static type conversions, 5-464

OracleTimeStampTZ Structure, 5-419

OracleTransaction

members, 4-338

properties, 4-340

public methods, 4-342

static methods, 4-340

OracleTruncateException

constructors, 5-513

members, 5-511

methods, 5-515

properties, 5-514

static methods, 5-514

OracleTruncateException Class, 5-510

OracleTypeException

constructors, 5-499

members, 5-497

properties, 5-500

static methods, 5-500

OracleTypeException Class, 5-496

OracleXmlPropertyCollection Class, 4-349

OracleXmlStream Class, 5-644

OracleXmlType, 3-52

OracleXmlType Class, 5-661

OS authentication, 4-69

Overview of ODP.NET Types, 5-2

Overview of Oracle Data Provider Classes, 4-2

parameter binding, 3-18

password expiration, 3-6

performance

array binding, 3-28

connection pooling, 3-3

fine-tuning FetchSize, 3-17

number of rows fetched, 3-16

Obtaining LOB Data, 3-15

PL/SQL Associative Array binding, 3-25

PL/SQL language, 3-31

PL/SQL REF CURSOR, 3-31

PL/SQL REF CURSOR and OracleRefCursor, 3-31

PLSQLAssociativeArray, 4-375

Pooling, 3-3

populating an OracleDataReader from a REF CURSOR, 3-32

populating an OracleRefCursor from a REF CURSOR, 3-32

populating the DataSet from a REF CURSOR, 3-32

preventing data loss, 3-44, 3-46

PrimaryKey property, 3-41

configuring, 3-42

privileged connections, 3-5

proxy authentication, 3-7

readme.txt, 2-3

REF CURSOR

behavior of ExecuteScalar method for, 3-33

obtaining, 3-31

populating DataSet from, 3-32

populating from OracleDataReader, 3-32

Requery property, 3-47

round-trip, 3-28

RowSize property, 3-17

Safe Type Mapping, 3-44

SafeMapping Property, 3-46

Samples, 1-8, 2-3

saving changes

to Oracle 8.1.7, 3-64

to Oracle9i, 3-65

using XML data, 3-62

SchemaTable, 4-173

session globalization parameters, 3-40

session globalization settings, 3-38

Size property, 3-25

special characters

in column data, 3-62

in table or view, 3-63

special characters in XML, 3-55

Stream class, 3-34

Syntax Used

described, 4-3

SYSDBA privileges, 3-5

SYSOPER privileges, 3-5

system requirements, 2-2

Oracle Data Provider for .NET, 2-2

table or view

special characters in, 3-63

TAF, 3-7

TAF callback support, 3-7

Temporary LOBs, 3-37

thread globalization settings, 3-40

thread-based globalization settings, 3-39

TraceFileName, 3-48

TraceLevel, 3-49

TraceOption, 3-49

Transaction object, 3-18

Transparent Application Failover (TAF), 3-7

troubleshooting, 3-48

Typed OracleDataReader Accessors, 3-11

unique columns, 3-14, 3-15

unique constraint, 3-14, 3-15

unique index, 3-14, 3-15

UniqueConstraint, 3-42

uniqueness

in updating dataset to database, 3-41

uniqueness in DataRows, 3-42

updating

LOBs, 3-35

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

updating LOBs using a DataSet, 3-35

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

updating LOBs using OracleCommand and OracleParameter, 3-36

updating without PrimaryKey and Constraints, 3-44

using FetchSize property, 3-16

Value property, 3-25

XLMType columns

setting to NULL, 3-54

XML

data manipulation using, 3-61

special characters, 3-55

XML data

saving changes using, 3-62

updating in OracleXmlType, 3-55

XML Database, 3-50

XML DB, 3-50

XML element name

case-sensitivity in, 3-63

XML Element Name to Column Name Mapping, 3-64

XML Support, 3-50

XMLType column

as a .NET String, 3-53

fetching into the DataSet, 3-53

updating with OracleCommand, 3-53