Index

A B C D E F G H I L M N O P Q R S T U V W X

A

abstract data types, 3.11

ADO, 1.2

ADO.NET, 1.2, 3.11.9

ADO.NET 1.x, 2.1

ADO.NET 2.0, 2.3, 3.2

base or DbCommon classes, 3.2.2

classes and class members, 3.2.9

DbCommon classes, 3.2

ADO.NET 2.x, 2.1

ADTs, 3.11

app.config

sample, 2.4.4

setting performance counters, 3.1.5.2

app.config file, 3.2.3

AppDomain, 3.1.5.3

application config, 2.4

array bind

OracleParameter, 3.4.2.5.1

array bind operations, 3.4.2.5

ArrayBindCount, 5

ArrayBindIndex, 5

ArrayBindSize, 5

ArrayBindStatus, 5

error handling, 3.4.2.5.2

array binding, 3.4.2.5

ArrayBindCount property, 5

ArrayBindIndex property, 5

ArrayBindSize property, 3.4.2.4, 3.4.2.5.1, 5

ArrayBindStatus property, 3.4.2.4, 3.4.2.5.1, 5

ASP.NET, 1.1.4

assembly, 1.3

ODP.NET, 1.3

B

batch processing, 3.2.8

support, 3.2

BatchUpdate

Microsoft Hotfix, 3.2.8

behavior of ExecuteScalar method for REF CURSOR, 3.7.7

BFILE, 3.9

BINARY_DOUBLE, 3.4.2.1

BINARY_FLOAT, 3.4.2.1

binding, 3.4.2

PL/SQL Associative Array, 3.4.2.4

BLOB, 3.9

bulk copy constraints, 3.2.10

bulk copy feature, 3.2.10

restrictions, 3.2.10

C

C#, Visual Basic .NET, C++ .NET, 1.1.1

caching ODP.NET parameter contexts, Preface

callback support, 3.1.14

case-sensitivity

column name mapping, 3.10.8.5

change notification

ODP.NET support, 3.13.2

change notification, Database Change Notification, 9

characters with special meaning

in column data, 3.10.8.3

in table or view, 3.10.8.4

characters with special meaning in XML, 3.10.6

client applications, 1.1.1

client globalization settings, 3.17.1.1, 3.17.2.1

client identifier, 3.1.13

CLOB, 3.9

close calls, 2.6

CLR, 1.1.3

collection types, 3.11.1, 3.11.1

CollectionType property, 3.4.2.4

column data

special characters in, 3.10.8.3

CommandBehavior.SequentialAccess, 3.6.2

commit transactions

changes to XML data, 3.10.8.10

CommittableTransaction, 3.2.7

config files

samples, 2.4.4

configuration settings

UDTs, 3.11.11

connect descriptor, 3.1.2

connection dependency, 3.10.3

connection optimization, 3.1.7.2

connection pool

performance counters, 3.1.5

connection pooling, 3.1.3

example, 3.1.3

for Oracle RAC database, 3.1.7

management, 3.1.4

Connection property, 3.9.2

connection string builder, 3.2

ConnectionString attributes, 3.1.3

Connection Lifetime, 3.1.1, 3.1.3, 3.1.3.1

Connection Timeout, 3.1.1, 3.1.3, 3.1.3.1

Data Source, 3.1.1

DBA Privilege, 3.1.1

Decr Pool Size, 3.1.1, 3.1.3, 3.1.3.1

Enlist, 3.1.1

HA Events, 3.1.1, 3.1.3

Incr Pool Size, 3.1.1, 3.1.3, 3.1.3.1

Load Balancing, 3.1.1, 3.1.3

Max Pool Size, 3.1.1, 3.1.3, 3.1.3.1

Metadata Pooling, 3.1.1

Min Pool Size, 3.1.1, 3.1.3, 3.1.3.1

Password, 3.1.1

Persist Security Info, 3.1.1

Pooling, 3.1.1, 3.1.3, 3.1.3.1

Proxy Password, 3.1.1, 3.1.11

Proxy User Id, 3.1.1, 3.1.11

Statement Cache Purge, 3.1.1

Statement Cache Size, 3.1.1

User Id, 3.1.1

Validate Connection, 3.1.1, 3.1.3, 3.1.3.1

ConnectionString property, 3.1.3, 3.1.3.1, 5

Constraints property, 3.16

configuring, 3.16.2

context connection, 4.2.1

Continuous Query Notification, 3.13

controlling query reexecution, 3.15

custom classes, 3.11.2

custom type factories, 3.11.2

custom type factory, 3.11.3.1

custom type implementations

optional, 3.11.2.2

custom type mapping, 3.11.3.1

custom type mappings

specifying, 3.11.3

specifying with custom type factories, 3.11.3

specifying with XML, 3.11.3

using, 3.11.3.3

custom types

converting to Oracle UDTS, 3.11.4

requirements, 3.11.2.1

custom UDT classes, 3.11.2

D

data loss, 3.14

data manipulation

using XML, 3.10.8

data source attribute, 3.1.2

data source enumerator, 3.2

data source enumerators, 3.2.4

database

changes to, 3.10.8

Database Change Notification

best practices, 3.13.5

performance considerations, 3.13.5

database change notification, 2.5, 3.13, 3.13.1

ODP.NET support, 3.13.2

database notification

port to listen, 2.5

DataSet, 3.9.3

populating, 3.7.4

populating from a REF CURSOR, 3.7.4

populating with generic and custom objects, 3.11.9

updating, 3.7.6

updating to database, 3.16

DataTable, 3.16.2

Datatable properties, 3.16

DbCommon classes, 3.2

DBlinks, 4.2.1

DbProviderFactories class, 2.3, 3.2.2

DbType

inference, 3.4.2.3

debug tracing, 3.18

default mapping

improving, 3.10.8.7.1

dependent unmanaged DLL mismatch, 2.3.2.1

direct path load, 3.2.10

dispose calls, 2.6

distributed transactions, 3.2.7

documentation

.NET, 1.1

Dynamic Enlistment, 3.1.12

dynamic help, 1.1.1, 2.3

E

Easy Connect naming method, 3.1.2.3

EDM type facets, 3.3.1.1

EDM types

and Oracle data types, 3.3.1

end-to-end tracing, 3.1.13

EnlistDistributedTransaction method, 3.1.12

Entity Framework, Preface, 3.3

enumeration type

OracleDbType, 3.4.2.2

error handling, 3.4.2.5.2

example

connection pooling, 3.1.3

examples

documentation

readme file, 2.3.1

ExecuteNonQuery method, 3.7.5

ExecuteScalar method, 3.7.7

explicit user connections, 4

EZCONNECT, 3.1.2.3

F

failover, 3.1.14

registering an event handler, 3.1.14

FailoverEvent Enumeration

description, 11

FailoverReturnCode Enumeration

description, 11

FailoverType Enumeration

description, 11

FAN, 3.1.7

Fast Application Notification (FAN), 3.1.7

features, 3

new, Preface

FetchSize property

fine-tuning, 3.6.4.2

setting at design time, 3.6.4.3.2

setting at run time, 3.6.4.3.3

using, 3.6.4.1

file locations, 2.3.1

G

garbage collection, 2.6

geographic data, 3.11

Global Assembly Cache (GAC), 2.3

globalization settings, 3.17, 3.17.1

client, 3.17.1.1

session, 3.17.1.2

thread-based, 3.17.1.3

globalization support, 3.17

globalization-sensitive operations, 3.17.2

Grid environment, 3.1.7

grid-computing, Preface, Preface

grids, Preface, Preface

GUI access to ODP.NET, 1.1.2

H

HA Events, 3.1.1, 3.1.7, 3.1.7.2

HA events, 2.5

handling date and time format

manipulating data in XML, 3.10.8.1

retrieving queries in XML, 3.10.7.1

I

implicit database connection, 4, 4.2.1, 4.2.2, 5

implicit REF CURSOR, Preface, 3.8

bind and metadata, 3.8.1

bindinfo, 3.8.1

configuration, 3.8.2

examples, 3.8.2

usage, 3.8.3

improving default mapping, 3.10.8.7.1

inference from Value property, 3.4.2.3.3

inference of DbType and OracleDbType from Value, 3.4.2.3.3

inference of DbType from OracleDbType, 3.4.2.3.1

inference of OracleDbType from DbType, 3.4.2.3.2

inference of types, 3.4.2.3

InitialLOBFetchSize property, 3.6.3

InitialLONGFetchSize property, 3.6.2

input binding

XMLType column, 3.10.4.2.1

installation, 2.3

Oracle Data Provider for .NET, 2.3

XCopy class, 2.3

integrated help, 2.3

interference in OracleParameter class, 3.4.2.3

introduction, overview, 1.2

INullable Interface

interface description, 14

interface members, 14

interface properties, 14

invalidation message, 3.13.1

ensuring persistency of, 3.13.2

InvalidCastException, 3.6.1.1

IOracleArrayTypeFactory Interface

interface description, 16

interface members, 16

interface methods, 16

IOracleCustomType Interface

interface description, 16

interface members, 16

interface methods, 16

IOracleCustomTypeFactory Interface

interface description, 16

interface members, 16

interface methods, 16

L

large binary datatypes, 3.9.1

large character datatypes, 3.9.1

limitations and restrictions, 4.2

LINQ to Entities, Preface, 3.3

Load Balancing, 3.1.1, 3.1.7

load balancing, 2.5

LOB Connection property, 3.9.2

LOB retrieval, Preface

LOBs

temporary, 3.9.6

updating, 3.9.4, 3.9.5

LOBs updating, 3.9.3

local transactions, 3.2.7

location data, 3.11

LONG and LONG RAW datatypes, 3.9.1

M

machine.config, 2.4

machine.config file, 2.3

metadata, 3.16.3

method invocation

UDT, 3.11.10

Microsoft ADO.NET 2.0, 3.2

Microsoft Common Language Runtime (CLR), 1.1.3

Microsoft Hotfix

BatchUpdate, 3.2.8

Microsoft .NET Framework, 2.1

Microsoft .NET Framework Class Library, 1.2

Microsoft Transaction Server, 2.1

MTS, 2.1

multiple notification requests, 3.13.2

Multiple Oracle Homes, Preface

multiple tables

changes to, 3.10.8.9

N

namespace

Oracle.DataAccess.Types, 1.3.2

native XML support, 3.10

NCLOB, 3.9

nested table types, 3.11.1

.NET custom types, 3.11

.NET Framework datatype, 3.5

.NET languages, 1.1.1, 1.1.2

.NET products and documentation, 1.1

.NET stored procedures and functions, 4.1

.NET Stream class, 3.9.2

.NET type accessors, 3.6.1.1

.NET Types

inference, 3.4.2.3

notification framework, 3.13.1

notification information

retrieving, 3.13.2

notification process

flow, 3.13.3

notification registration, 3.13.2, 3.13.2

requirements of, 3.13.3

NULL values

retrieving from column, 3.10.7.7

number of rows fetched in round-trip

controlling, 3.6.4

O

object data type support, 3.11

object types, 3.11.1, 3.11.1

object-relational data, 3.10.7.6

saving changes from XML data, 3.10.8.8

obtaining a REF CURSOR, 3.7.2, 3.7.4

obtaining an OracleRefCursor, 3.7.1

obtaining data from an OracleDataReader, 3.6

obtaining LOB data

InitialLOBFetchSize property, 3.6.3

obtaining LONG and LONG RAW Data, 3.6.2, 3.6.2

OCI

statement caching, 3.4.3

OData, Preface

ODP.NET

installing, 2.3

ODP.NET Configuration, 2.4

ODP.NET LOB classes, 3.9

ODP.NET Type accessors, 3.6.1.2

ODP.NET Type classes, 3.5

ODP.NET Type exceptions, 15

ODP.NET Type structures, 3.5, 14

ODP.NET Types, 3.5

overview, 3.5

ODP.NET within a .NET stored procedure

limitations and restrictions, 4.2

transaction support, 4.2.2

unsupported SQL commands, 4.2.3

ODP.NET XML Support, 3.10

OnChangedEventArgs Class

instance properties, 9

members, 9

static fields, 9

static methods, 9

OnChangeEventHandler Delegate

description, 9

operating system authentication, 3.1.8

Oracle Call Interface

statement caching, 3.4.3

Oracle Data Guard

connecting, 3.1.7.2

Oracle Data Provider for .NET

installing, 2.3

system requirements, 2.1

Oracle Data Provider for .NET assembly, 1.3

Oracle data types

and EDM types, 3.3.1

mapping and customizing, 3.3.2

Oracle Database Extensions for .NET, 1.1.3, 4

Oracle Developer Tools for Visual Studio, 1.1.2

Oracle Label Security, 3.1.13

Oracle native types, 3.5

supported by ODP.NET, 3.6.1.1

Oracle Providers for ASP.NET, 1.1.4

Oracle RAC

connecting, 3.1.7.1

Oracle RAC database

pool size attributes, 3.1.7.3, 3.1.7.3

Oracle RAC environment, 3.1.7

Oracle Services for Microsoft Transaction Server, 2.1

Oracle UDT attribute mappings, 3.11.5

Oracle Universal Installer (OUI), 2.3

Oracle user-defined types, 3.11

Oracle User-Defined Types (UDTs), 3.11.1

Oracle Virtual Private Database (VPD), 3.1.13

Oracle XML DB, 3.10.1

Oracle8i Database, ADO.NET 2.0

interfaces, 3.2

OracleAQAgent

constructors, 12

OracleAQAgent Class

constructors, 12

description, 12

members, 12, 12, 12

properties, 12, 12, 12

OracleAQDequeueMode Enumeration

description, 12

OracleAQDequeueOptions Class

constructor, 12

description, 12

members, 12

properties, 12

public methods, 12

OracleAQEnqueueOptions Class

constructor, 12

description, 12

members, 12

properties, 12

public methods, 12

OracleAQMessage Class

constructors, 12

description, 12

members, 12

properties, 12

OracleAQMessageAvailableEventArgs Class

description, 12

members, 12

properties, 12

OracleAQMessageAvailableEventHandler Delegate

description, 12

OracleAQMessageDeliveryMode Enumeration

description, 12

OracleAQMessageState Enumeration

description, 12

OracleAQMessageType Enumeration

description, 12

OracleAQNavigationMode Enumeration

description, 12

OracleAQNotificationGroupingType Enumeration

description, 12

OracleAQNotificationType Enumeration

description, 12

OracleAQQueue Class

constructors, 12

description, 12

events, 12

members, 12

properties, 12

public methods, 12

static methods, 12

OracleAQVisibilityMode Enumeration

description, 12

OracleArrayMappingAttribute Class

constructors, 16

description, 16

members, 16

methods, 16

properties, 16

static methods, 16

OracleBFile Class

class description, 13

constructors, 13

instance methods, 13

instance properties, 13

members, 13

static fields, 13

static methods, 13

OracleBinary Structure

constructor, 14

description, 14

instance methods, 14

members, 14

properties, 14

static fields, 14

static methods, 14

static operators, 14

static type conversion operators, 14

OracleBlob Class

class description, 13

constructors, 13

instance methods, 13

instance properties, 13

members, 13

static fields, 13

static methods, 13

OracleBulkCopy Class

class description, 17

constructors, 17

events, 17

members, 17

properties, 17

public methods, 17

OracleBulkCopyColumnMapping Class

class description, 17

constructors, 17

members, 17

properties, 17

OracleBulkCopyColumnMappingCollection Class

class description, 17

members, 17

properties, 17

public methods, 17

OracleBulkCopyOptions Enumeration

description, 17

OracleClientFactory, 2.3

OracleClientFactory Class

class description, 7

class members, 7

public methods, 7

public properties, 7

OracleClientFactory class

instantiating, 3.2.2

OracleClob Class

class description, 13

constructors, 13

instance methods, 13

instance properties, 13

members, 13

static fields, 13

static methods, 13

OracleCollectionType Enumeration, 5

OracleCommand

ArrayBindCount property, 3.4.2.5

constructors, 5

InitialLOBFetchSize property, 3.6.3

InitialLONGFetchSize property, 3.6.2

Transaction property, 3.4

OracleCommand Class

ArrayBindCount, 5

class description, 5

ExecuteScalar method, 3.7.7

FetchSize property, 3.6.4.1

members, 5

properties, 5

public methods, 5, 12

RowSize property, 3.6.4.3

static methods, 5

OracleCommand object, 3.4

OracleCommand properties

ArrayBindCount, 3.4.2.5

OracleCommand Transaction object, 3.4.1

OracleCommandBuilder Class, 3.16.3

class description, 5

constructors, 5

events, 5

members, 5

properties, 5

public methods, 5

static methods, 5

updating dataset, 3.16

OracleConnection

ClearAllPools property, 3.1.4

ClearPool property, 3.1.4

ClientId property, 3.1.13

events, 5

OracleConnection Class

class description, 5

constructors, 5

members, 5

obtaining a reference, 3.10.3

properties, 5

public methods, 5

static methods, 5

OracleConnection class

GetSchema methods, 3.2.6

OracleConnectionStringBuilder Class

class description, 7

class members, 7

constructors, 7

public methods, 7

public properties, 7

OracleConnectionStringBuilder class

using, 3.2.3

OracleConnectionType Enumeration

description, 5

OracleCustomTypeMappingAttribute Class

constructors, 16

description, 16

members, 16

methods, 16

properties, 16

static methods, 16

Oracle.DataAccess.Client namespace, 1.3

Oracle.DataAccess.dll, 1.3

Oracle.DataAccess.Types namespace, 1.3, 1.3.2

OracleDataAdapter, 3.14

constructors, 5

members, 5

SafeMapping Property, 3.14.2

SelectCommand property, 3.7.4

OracleDataAdapter Class, 5

events, 5

FillSchema method, 3.16.3

properties, 5

public methods, 5

SelectCommand property, 3.16.3

static methods, 5

OracleDataAdapter class

FillSchema method, 3.16.2

Requery property, 3.15

SelectCommand property, 3.16.1

OracleDataAdapter Safe Type Mapping, 3.14

OracleDatabase Class

class description, 5

constructor, 5

members, 5

properties, 5

public methods, 5

Shutdown method, 5

Startup method, 5

OracleDataReader, 3.6, 3.6.2

members, 5

retrieving UDTs from, 3.11.6

typed accessors, 3.6.1

OracleDataReader Class

class description, 5

FetchSize property, 3.6.4.1

populating, 3.7.3

properties, 5

public methods, 5

static methods, 5

OracleDataReader Class SchemaTable, 5

OracleDataSource Enumerator class

using, 3.2.4

OracleDataSourceEnumerator Class

class description, 7

class members, 7

public methods, 7

OracleDate Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static fields, 14

static methods, 14

static operators, 14

static type conversions, 14

OracleDBShutdownMode Enumeration

description, 5

OracleDBStartupMode Enumeration

description, 5

OracleDbType

inference, 3.4.2.3

OracleDbType enumeration, 3.4.2.3

OracleDbType enumeration type, 3.4.2.2, 5

OracleDecimal Structure

constructors, 14

description, 14

instance methods, 14

members, 14

properties, 14

static comparison methods, 14

static comparison operators, 14

static logarithmic methods, 14

static manipulation methods, 14

static operators, .NET Type to OracleDecimal, 14

static operators, OracleDecimal to .NET, 14

static trignonmetric methods, 14

OracleDependency Class

change notification, 3.13.1

class description, 9

constructors, 9

database change notification, 3.13

events, 9

instance methods, 9

instance properties, 9

members, 9

static fields, 9

static methods, 9

OracleError Class

ArrayBindIndex, 5

class description, 5

members, 5

methods, 5

properties, 5

static methods, 5

OracleErrorCollection

members, 5

properties, 5

public methods, 5

static methods, 5

OracleErrorCollection Class, 5

OracleException

members, 5

methods, 5

properties, 5

static methods, 5

OracleException Class, 5

OracleFailoverEventArgs

members, 11

properties, 11

public methods, 11

OracleFailoverEventHandler Delegate

description, 11

OracleGlobalization Class

class description, 10

members, 10

properties, 10

public methods, 10

OracleHAEventArgs Class

description, 8

members, 8

properties, 8

OracleHAEventHandler Delegate

description, 8

OracleHAEventSource Enumeration

description, 8

OracleHAEventStatus Enumeration

description, 8

OracleInfoMessageEventArgs

members, 5

properties, 5

public methods, 5

static methods, 5

OracleInfoMessageEventHandler Delegate, 5

OracleIntervalDS Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static methods, 14

static operators, 14

type conversions, 14

OracleIntervalYM Structure

constructors, 14

description, 14

members, 14

methods, 14, 14

properties, 14

static fields, 14

static operators, 14

type conversions, 14

OracleNotificationEventArgs Class

change notification, 3.13.1

class description, 9

instance methods, 9

OracleNotificationInfo Enumeration

description, 9

OracleNotificationRequest Class

change notification, 3.13.1

class description, 9

database change notification, 3.13

instance methods, 9

instance properties, 9

members, 9

static methods, 9

OracleNotificationSource Enumeration

description, 9

OracleNotificationType Enumeration

description, 9

OracleNullValueException Class

class description, 15

constructors, 15

members, 15

methods, 15, 15

properties, 15

OracleObjectMappingAttribute Class

constructors, 16

description, 16

members, 16

methods, 16

properties, 16

static methods, 16

OracleParameter

array bind properties, 3.4.2.5.1

ArrayBindSize property, 3.4.2.5.1, 5

ArrayBindStatus property, 3.4.2.5.1, 5

constructors, 5

inferences of types, 3.4.2.3

members, 5

properties, 5

public methods, 5

static methods, 5

OracleParameter array bind feature, 3.4.2.5

OracleParameter Class, 5, 5

Value, 3.4.2.3.3

OracleParameter object, 3.4.2

OracleDbType enumerated values, 3.4.2.2

OracleParameter property

ArrayBindSize, 3.4.2.4

ArrayBindStatus, 3.4.2.4

CollectionType, 3.4.2.4

Size, 3.4.2.4

Value, 3.4.2.4

OracleParameterCollection

members, 5

public methods, 5

static methods, 5

OracleParameterCollection Class, 5

OracleParameterStatus enumeration type, 3.4.2.5.3, 5

OraclePermission Class

constructor, 5

members, 5

public methods, 5

public properties, 5

static methods, 5

Oraclepermission Class

description, 5

OraclePermissionAttribute Class

constructor, 5, 5

description, 5

members, 5

public methods, 5

public properties, 5

static methods, 5

OracleRef Class

class description, 16

class members, 16

constructors, 16

instance methods, 16

instance properties, 16

static fields, 16

static methods, 16

OracleRefCursor, 3.7

OracleRefCursor Class

class description, 13

instance methods, 13

members, 13

populating from a REF CURSOR, 3.7.5

properties, 13

static methods, 13

OracleRowsCopiedEventArgs Class

class description, 17

constructors, 17

members, 17

properties, 17

OracleRowsCopiedEventHandler Delegate

description, 17

OracleRowUpdatedEventArgs

constructor, 5

members, 5

properties, 5

public methods, 5

static methods, 5

OracleRowUpdatedEventArgs Class, 5

OracleRowUpdatedEventHandler Delegate, 5

OracleRowUpdatingEventArgs

constructor, 5

members, 5

properties, 5

public methods, 5

static methods, 5

OracleRowUpdatingEventArgs Class, 5

OracleRowUpdatingEventHandler Delegate, 5

OracleString Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static fields, 14

static methods, 14

static operators, 14

type conversions, 14

OracleTimeStamp Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static methods, 14

static operators, 14

static type conversions, 14

OracleTimeStampLTZ Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static fields, 14

static methods, 14

static operators, 14

static type conversions, 14

OracleTimeStampTZ Structure

constructors, 14

description, 14

members, 14

methods, 14

properties, 14

static fields, 14

static methods, 14

static operators, 14

static type conversions, 14

OracleTransaction

members, 5

properties, 5

public methods, 5

static methods, 5

OracleTransaction Class

class description, 5

OracleTruncateException Class

class description, 15

constructors, 15

members, 15

methods, 15

properties, 15

static methods, 15

OracleTypeException Class

class description, 15

constructors, 15

members, 15

properties, 15

static methods, 15

OracleUdt Class

description, 16

members, 16

static methods, 16

OracleUdtFetchOption Enumeration

description, 16

OracleUdtStatus Enumeration

description, 16

OracleXmlCommandType Enumeration, 6

OracleXmlQueryProperties Class

class description, 6

constructors, 6

members, 6

properties, 6

public methods, 6

OracleXmlSaveProperties Class, 6

constructors, 6

members, 6

properties, 6

public methods, 6

OracleXmlStream Class

class description, 6

constructors, 6

instance methods, 6

instance properties, 6

members, 6

static methods, 6

OracleXmlType Class, 3.10.3

class description, 6

constructors, 6

instance methods, 6

instance properties, 6

members, 6

static methods, 6

P

parameter binding, 3.4.2

parameter binding with OracleParameter, 3.11.8

parameter context caching, Preface

password expiration, 3.1.10

passwords in code examples, Preface

performance, 3.4.3

array binding, 3.4.2.5

connection pooling, 3.1.3

fine-tuning FetchSize, 3.6.4.2

number of rows fetched, 3.6.4

Obtaining LOB Data, 3.6.3

performance counters

connection pool, 3.1.5

instance names of, 3.1.5.3

publishing, 3.1.5

using app.config entry, 3.1.5.2

PL/SQL Associative Array binding, 3.4.2.4

PL/SQL Index-By Tables, 3.4.2.4

PL/SQL language, 3.7

PL/SQL REF CURSOR, 3.7

PL/SQL REF CURSOR and OracleRefCursor, 3.7

PLSQLAssociativeArray, 5

populating an OracleDataReader from a REF CURSOR, 3.7.3

populating an OracleRefCursor from a REF CURSOR, 3.7.5

populating the DataSet from a REF CURSOR, 3.7.4

populating the DataSet with generic and custom objects, 3.11.9

port

listen for database notifications, 2.5

port number

defining listener, 3.13.2

porting

client application to .NET stored procedure, 4.3

preventing data loss, 3.14, 3.14.2

PrimaryKey property, 3.16

configuring, 3.16.2

privileged connections, 3.1.9

promotable transactions, 3.2.7

properties

ClientId property, 3.1.13

provider factory classes, 3.2, 3.2.2

provider independence, 3.2

proxy authentication, 3.1.11

Q

query result set

retrieving as XML, 3.10.7

R

REF CURSOR

behavior of ExecuteScalar method, 3.7.7

implicit, Preface, 3.8

obtaining, 3.7.2, 3.7.4

passing to stored procedure, 3.7.8

populating DataSet from, 3.7.4

populating from OracleDataReader, 3.7.3

registry entries, 2.4

release Oracle8i (8.1.7), 3.10.8.1

release Oracle9i(9.0.x), 3.10.8.1

Requery property, 3.15

round-trip, 3.4.2.5

RowSize property, 3.6.4.3

Runtime Connection Load Balancing, 3.1.7

S

Safe Type Mapping, 3.14

SafeMapping Property, 3.14.2

Samples, 1.4

samples, 2.3.1

UDT, 16

saving change using an XML document, 3.10.8.7

saving changes

using XML data, 3.10.8.2

schema metadata

customizing metadata, 3.2.6

SchemaTable, 5

search order

unmanaged DLLs, 2.3.2

SecureFiles, Preface, 3.9

SelectCommand property, 3.7.4

session globalization parameters, 3.17.2.3

session globalization settings, 3.17.1.2

shema discovery

support, 3.2

Shutdown method, 5

simple application, 1.4

Size property, 3.4.2.4

SQL commands

unsupported, 4.2.3

Startup method, 5

Statement Caching

connection string attributes, 3.4.3.1

methods and properties, 3.4.3.3

Statement Cache Purge, 3.4.3

Statement Cache Size, 3.4.3

StatementCacheWithUdts, 3.11.11

stored procedures and functions, 3.7.8, 4.1

Stream class, 3.9.2

support comparison

client application versus .NET stored procedure, 4.3

SYSDBA privileges, 3.1.9

SYSOPER privileges, 3.1.9

system requirements

Oracle Data Provider for .NET, 2.1

System.Data.Common, 3.2

System.Transactions support, 3.2.7

T

table or view

special characters in, 3.10.8.4

TAF, 3.1.14

TAF callback support, 3.1.14

Temporary LOBs, 3.9.6

thread globalization settings, 3.17.2.2

Thread.Abort method, 2.6

thread-based globalization settings, 3.17.1.3

tips for ODP.NET, 2.6

TNS alias, 3.1.2

tracing attributes, 3.1.13

Transaction object, 3.4.1

Transaction property, 3.4

transaction support, 4.2.2

transactions

commit, 3.10.8.10

TransactionScope, 3.2.7

Transparent Application Failover (TAF), 3.1.14

troubleshooting, 3.18

typed OracleDataReader accessors, 3.6.1

U

UDT

method invocation, 3.11.10

UDT metadata retrieval from OracleDataReader, 3.11.7

UdtCacheSize, 3.11.11

UDTs, 3.11

collection types, 3.11.1

configuration settings, 3.11.11

object types, 3.11.1

parameter binding with OracleParameter, 3.11.8

retrieving from OracleDataReader, 3.11.6

samples, 16

UDTs (Oracle User-Defined Types), 3.11.1

UdtTypeName property, 3.11.8

unique columns, 3.6.2, 3.6.3

unique constraint, 3.6.2, 3.6.3

unique index, 3.6.2, 3.6.3

UniqueConstraint, 3.16.2

uniqueness

in updating DataSet to database, 3.16

uniqueness in DataRows, 3.16.1

unmanaged DLLs

mismatch, 2.3.2.1

search order, 2.3.2

unmanged DLLs

config support, 2.3.2

unsupported SQL commands, 4.2.3

updating

LOBs, 3.9.3

updating a DataSet obtained from a REF CURSOR, 3.7.6

updating LOBs using a DataSet, 3.9.3

updating LOBs using ODP.NET LOB objects, 3.9.5

updating LOBs using OracleCommand and OracleParameter, 3.9.4

updating without PrimaryKey and Constraints, 3.16.3

user-defined types, 3.11

using FetchSize property, 3.6.4.1

V

Value property, 3.4.2.4

VARRAY types, 3.11.1

Virtual Private Database(VPD), 3.1.13

Visual Studio

documentation, 2.3

W

WCF Data Services, Preface

web.config, 2.4

Windows registry, 2.4.2

X

XML

characters with special meaning, 3.10.6

data manipulation using, 3.10.8

XML data

saving changes using, 3.10.8.2

updating in OracleXmlType, 3.10.5

XML Database, 3.10

XML DB, 3.10, 3.10.2

XML element name

case-sensitivity in, 3.10.8.5

XML Element Name to Column Name Mapping, 3.10.8.6

XML related classes, 6

XML related enumerations, 6

XML Support, 3.10

XML to specify custom type mappings, 3.11.3.2

XMLQuery, 3.10.1

XMLTable, 3.10.1

XMLType column

as a .NET String, 3.10.4.1

fetching into the DataSet, 3.10.4.1

updating with OracleCommand, 3.10.4.2

XMLType columns

setting to NULL, 3.10.4.2.2

XQUERY, 3.10.1

XQuery

support, 3.10.2

XQuery language, 3.10.1