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, 2.5, 3.13, 3.13.1
ODP.NET support, 3.13.2
Database Change Notification
best practices, 3.13.5
performance considerations, 3.13.5
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, 2.5
HA Events, 3.1.1, 3.1.7, 3.1.7.2
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, 2.5
Load Balancing, 3.1.1, 3.1.7
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
instantiating, 3.2.2
OracleClientFactory Class
class description, 7
class members, 7
public methods, 7
public properties, 7
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
GetSchema methods, 3.2.6
OracleConnection Class
class description, 5
constructors, 5
members, 5
obtaining a reference, 3.10.3
properties, 5
public methods, 5
static methods, 5
OracleConnectionStringBuilder class
using, 3.2.3
OracleConnectionStringBuilder Class
class description, 7
class members, 7
constructors, 7
public methods, 7
public properties, 7
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
FillSchema method, 3.16.2
Requery property, 3.15
SelectCommand property, 3.16.1
OracleDataAdapter Class, 5
events, 5
FillSchema method, 3.16.3
properties, 5
public methods, 5
SelectCommand property, 3.16.3
static methods, 5
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
description, 5
OraclePermission Class
constructor, 5
members, 5
public methods, 5
public properties, 5
static methods, 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, 2.3.1
UDT, 16
Samples, 1.4
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
support, 3.10.2
XQUERY, 3.10.1
XQuery language, 3.10.1