Index

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

A

ADO, 1.2
ADO.NET, 1.2
backward compatibility, 3.2.2
ADO.NET 1.x, 2.1
ADO.NET 2.0, 2.3, 3.2
base or DbCommon classes, 3.2.3
DbCommon classes, 3.2
ADO.NET 2.x, 2.1
app.config file, 3.2.4
application config, 3.15
array bind
OracleParameter, 3.3.2.5.1
array bind operations, 3.3.2.5
ArrayBindCount, 5
ArrayBindIndex, 5
ArrayBindSize, 5
ArrayBindStatus, 5
error handling, 3.3.2.5.2
array binding, 3.3.2.5
ArrayBindCount property, 5
ArrayBindIndex property, 5
ArrayBindSize property, 3.3.2.4, 3.3.2.5.1, 5
ArrayBindStatus property, 3.3.2.4, 3.3.2.5.1, 5
assembly, 1.3
ODP.NET, 1.3

B

batch processing
support, 3.2
behavior of ExecuteScalar method for REF CURSOR, 3.6.7
BFILE, 3.7
BINARY_DOUBLE, 3.3.2.1
BINARY_FLOAT, 3.3.2.1
binding, 3.3.2
PL/SQL Associative Array, 3.3.2.4
BLOB, 3.7

C

callback support, 3.1.12
case-sensitivity
column name mapping, 3.8.8.5
change notification
ODP.NET support, 3.9.2
change notification, Database Change Notification, 8
characters with special meaning
in column data, 3.8.8.3
in table or view, 3.8.8.4
characters with special meaning in XML, 3.8.6
client applications, 1.1.1
client globalization settings, 3.13.1.1, 3.13.2.1
client identifier, 3.1.11
CLOB, 3.7
CLR, 1.1.3
CollectionType property, 3.3.2.4
column data
special characters in, 3.8.8.3
CommandBehavior.SequentialAccess, 3.5.2
commit transactions
changes to XML data, 3.8.8.10
connection dependency, 3.8.3
connection pooling, 3.1.3
example, 3.1.3
for RAC database, 3.1.5
management, 3.1.4
Connection property, 3.7.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.9
Proxy User Id, 3.1.1, 3.1.9
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.12
configuring, 3.12.2
context connection, 4.2.1
Continuous Query Notification, 3.9
controlling query reexecution, 3.11

D

data loss, 3.10
data manipulation
using XML, 3.8.8
data source enumerator, 3.2
data source enumerators, 3.2.5
database
changes to, 3.8.8
Database Change Notification
best practices, 3.9.5
performance considerations, 3.9.5
database change notification, 3.9, 3.9.1
ODP.NET support, 3.9.2
DataSet, 3.7.3
populating, 3.6.4
populating from a REF CURSOR, 3.6.4
updating, 3.6.6
updating to database, 3.12
DataTable, 3.12.2
Datatable properties, 3.12
DbCommon classes, 3.2
DBlinks, 4.2.1
DbProviderFactories class, 2.3, 3.2.3
DbType
inference, 3.3.2.3
debug tracing, 3.14
registry settings, 3.14.1
default mapping
improving, 3.8.8.7.1
documentation, 2.4
.NET, 1.1
dynamic help, 1.1.1, 2.3

E

enlist=dynamic,EnlistDistributedTransaction method,DynamicEnlistment, 3.1.10
enumeration type
OracleDbType, 3.3.2.2
error handling, 3.3.2.5.2
example
connection pooling, 3.1.3
ExecuteNonQuery method, 3.6.5
ExecuteScalar method, 3.6.7
explicit user connections, 4

F

failover, 3.1.12
registering an event handler, 3.1.12
FailoverEvent Enumeration
description, 10
FailoverReturnCode Enumeration
description, 10
FailoverType Enumeration
description, 10
FAN, 3.1.5
Fast Application Notification (FAN), 3.1.5
features, 3
new, Preface
FetchSize property
fine-tuning, 3.5.4.2
setting at design time, 3.5.4.3.1
setting at runtime, 3.5.4.3.2
using, 3.5.4.1
file locations, 2.4

G

Global Assembly Cache (GAC), 2.3
globalization settings, 3.13.1
client, 3.13.1.1
session, 3.13.1.2
thread-based, 3.13.1.3
globalization support, 3.13
globalization-sensitive operations, 3.13.2
Grid environment, 3.1.5
grid-computing, Preface, Preface
grids, Preface, Preface
GUI access to ODP.NET, 1.1.2

H

HA Events, 3.1.1, 3.1.5
debug tracing information, 3.14.1.2
handling date and time format
manipulating data in XML, 3.8.8.1
retrieving queries in XML, 3.8.7.1

I

implicit database connection, 4, 4.2.1, 4.2.2, 5
improving default mapping, 3.8.8.7.1
inference from Value property, 3.3.2.3.3
inference of DbType and OracleDbType from Value, 3.3.2.3.3
inference of DbType from OracleDbType, 3.3.2.3.1
inference of OracleDbType from DbType, 3.3.2.3.2
inference of types, 3.3.2.3
InitialLOBFetchSize property, 3.5.3
InitialLONGFetchSize property, 3.5.2
input binding
XMLType column, 3.8.4.2.1
installation, 2.3
Oracle Data Provider for .NET, 2.3
integrated help, 2.3
interference in OracleParameter class, 3.3.2.3
introduction, overview, 1.2
invalidation message, 3.9.1
ensuring persistency of, 3.9.2
InvalidCastException, 3.5.1.1

L

large binary datatypes, 3.7.1
large character datatypes, 3.7.1
limitations and restrictions, 4.2
Load Balancing, 3.1.1, 3.1.5
debug tracing information, 3.14.1.2
LOB Connection property, 3.7.2
LOBs
temporary, 3.7.6
updating, 3.7.4, 3.7.5
LOBs updating, 3.7.3
LONG and LONG RAW datatypes, 3.7.1

M

machine.config, 3.15
machine.config file, 2.3
metadata, 3.12.3
Microsoft ADO.NET 2.0, 3.2
Microsoft Common Language Runtime (CLR), 1.1.3
Microsoft .NET Framework, 2.1
Microsoft .NET Framework Class Library, 1.2
Microsoft Transaction Server, 2.1
MTS, 2.1
multiple notification requests, 3.9.2
Multiple Oracle Homes, Preface
multiple tables
changes to, 3.8.8.9

N

namespace
Oracle.DataAccess.Types, 1.3.2
native XML support, 3.8
NCLOB, 3.7
.NET Framework datatype, 3.4
.NET languages, 1.1.2
.NET products and documentation, 1.1
.NET stored procedures and functions, 4.1
.NET Stream class, 3.7.2
.NET type accessors, 3.5.1.1
.NET Types
inference, 3.3.2.3
notification framework, 3.9.1
notification information
retrieving, 3.9.2
notification process
flow, 3.9.3
notification registration, 3.9.2, 3.9.2
requirements of, 3.9.3
NULL values
retrieving from column, 3.8.7.7
number of rows fetched in round-trip
controlling, 3.5.4

O

object-relational data, 3.8.7.6
saving changes from XML data, 3.8.8.8
obtaining a REF CURSOR, 3.6.2, 3.6.4
obtaining an OracleRefCursor, 3.6.1
obtaining data from an OracleDataReader, 3.5
obtaining LOB data
InitialLOBFetchSize property, 3.5.3
obtaining LONG and LONG RAW Data, 3.5.2, 3.5.2
OCI
statement caching, 3.3.3
ODP.NET
installing, 2.3
ODP.NET Configuration, 3.15
ODP.NET LOB classes, 3.7
ODP.NET Type accessors, 3.5.1.2
ODP.NET Type classes, 3.4
ODP.NET Type exceptions, 13
ODP.NET Type structures, 3.4, 12
ODP.NET Types, 3.4
overview, 3.4
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.8
OnChangedEventArgs Class
instance properties, 8
members, 8
static fields, 8
static methods, 8
OnChangeEventHandler Delegate
description, 8
operating system authentication, 3.1.6
Oracle Call Interface
statement caching, 3.3.3
Oracle Data Provider for .NET
installing, 2.3
system requirements, 2.1
Oracle Data Provider for .NET assembly, 1.3
Oracle Database Extensions for .NET, 1.1.3, 4
Oracle Developer Tools for Visual Studio .NET, 1.1.2
Oracle Label Security, 3.1.11
Oracle native types, 3.4
supported by ODP.NET, 3.5.1.1
Oracle Services for Microsoft Transaction Server, 2.1
Oracle Universal Installer (OUI), 2.3
Oracle Virtual Private Database (VPD), 3.1.11
Oracle XML DB, 3.8.1
ORACLE_BASEORACLE_HOMEodp.netbin directory, 2.4
Oracle8i Database, ADO.NET 2.0
interfaces, 3.2
OracleBFile Class
class description, 11
constructors, 11
instance methods, 11
instance properties, 11
members, 11
static fields, 11
static methods, 11
OracleBinary Structure
constructor, 12
description, 12
instance methods, 12
members, 12
properties, 12
static fields, 12
static methods, 12
static operators, 12
static type conversion operators, 12
OracleBlob Class
class description, 11
constructors, 11
instance methods, 11
instance properties, 11
members, 11
static fields, 11
static methods, 11
OracleClientFactory Class
class description, 7
class members, 7
public methods, 7
public properties, 7
OracleClientFactory class, 2.3
instantiating, 3.2.3
OracleClob Class
class description, 11
constructors, 11
instance methods, 11
instance properties, 11
members, 11
static fields, 11
static methods, 11
OracleCollectionType Enumeration, 5
OracleCommand
ArrayBindCount property, 3.3.2.5
constructors, 5
InitialLOBFetchSize property, 3.5.3
InitialLONGFetchSize property, 3.5.2
Transaction property, 3.3
OracleCommand Class
ArrayBindCount, 5
class description, 5
ExecuteScalar method, 3.6.7
FetchSize property, 3.5.4.1
members, 5
properties, 5
public methods, 5
RowSize property, 3.5.4.3
static methods, 5
OracleCommand object, 3.3
OracleCommand properties
ArrayBindCount, 3.3.2.5
OracleCommand Transaction object, 3.3.1
OracleCommandBuilder Class, 3.12.3
class description, 5
constructors, 5
events, 5
members, 5
properties, 5
public methods, 5
static methods, 5
updating dataset, 3.12
OracleConnection
ClearAllPools property, 3.1.4
ClearPool property, 3.1.4
ClientId property, 3.1.11
events, 5
OracleConnection Class
class description, 5
constructors, 5
members, 5
obtaining a reference, 3.8.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.4
Oracle.DataAccess.Client namespace, 1.3
Oracle.DataAccess.dll, 1.3
Oracle.DataAccesss.dll assembly, 2.4
Oracle.DataAccess.Types namespace, 1.3, 1.3.2
OracleDataAdapter, 3.10
constructors, 5
members, 5
SafeMapping Property, 3.10.2
SelectCommand property, 3.6.4
OracleDataAdapter Class, 5
events, 5
FillSchema method, 3.12.3
properties, 5
public methods, 5
SelectCommand property, 3.12.3
static methods, 5
OracleDataAdapter class
FillSchema method, 3.12.2
Requery property, 3.11
SelectCommand property, 3.12.1
OracleDataAdapter Safe Type Mapping, 3.10
OracleDataReader, 3.5, 3.5.2
members, 5
typed accessors, 3.5.1
OracleDataReader Class
class description, 5
FetchSize property, 3.5.4.1
populating, 3.6.3
properties, 5
public methods, 5
static methods, 5
OracleDataReader Class SchemaTable, 5
OracleDataSource Enumerator class
using, 3.2.5
OracleDataSourceEnumerator Class
class description, 7
class members, 7
public methods, 7
OracleDate Structure
constructors, 12
description, 12
members, 12
methods, 12
properties, 12
static fields, 12
static methods, 12
static operators, 12
static type conversions, 12
OracleDbType
inference, 3.3.2.3
OracleDbType enumeration, 3.3.2.3
OracleDbType enumeration type, 3.3.2.2, 5
OracleDecimal Structure
constructors, 12
description, 12
instance methods, 12
members, 12
properties, 12
static comparison methods, 12
static comparison operators, 12
static logarithmic methods, 12
static manipulation methods, 12
static operators, .NET Type to OracleDecimal, 12
static operators, OracleDecimal to .NET, 12
static trignonmetric methods, 12
OracleDependency Class
change notification, 3.9.1
class description, 8
constructors, 8
database change notification, 3.9
events, 8
instance methods, 8
instance properties, 8
members, 8
static fields, 8
static methods, 8
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, 10
properties, 10
public methods, 10
OracleFailoverEventHandler Delegate
description, 10
OracleGlobalization Class
class description, 9
members, 9
properties, 9
public methods, 9
OracleInfoMessageEventArgs
members, 5
properties, 5
public methods, 5
static methods, 5
OracleInfoMessageEventHandler Delegate, 5
OracleIntervalDS Structure
constructors, 12
description, 12
members, 12
methods, 12
properties, 12
static methods, 12
static operators, 12
type conversions, 12
OracleIntervalYM Structure
constructors, 12
description, 12
members, 12
methods, 12, 12
properties, 12
static fields, 12
static operators, 12
type conversions, 12
OracleNotificationEventArgs Class
change notification, 3.9.1
class description, 8
instance methods, 8
OracleNotificationInfo Enumeration
description, 8
OracleNotificationRequest Class
change notification, 3.9.1
class description, 8
database change notification, 3.9
instance methods, 8
instance properties, 8
members, 8
static methods, 8
OracleNotificationSource Enumeration
description, 8
OracleNotificationType Enumeration
description, 8
OracleNullValueException Class
class description, 13
constructors, 13
members, 13
methods, 13, 13
properties, 13
OracleParameter
array bind properties, 3.3.2.5.1
ArrayBindSize property, 3.3.2.5.1, 5
ArrayBindStatus property, 3.3.2.5.1, 5
constructors, 5
inferences of types, 3.3.2.3
members, 5
properties, 5
public methods, 5
static methods, 5
OracleParameter array bind feature, 3.3.2.5
OracleParameter Class, 5, 5
Value, 3.3.2.3.3
OracleParameter object, 3.3.2
OracleDbType enumerated values, 3.3.2.2
OracleParameter property
ArrayBindSize, 3.3.2.4
ArrayBindStatus, 3.3.2.4
CollectionType, 3.3.2.4
Size, 3.3.2.4
Value, 3.3.2.4
OracleParameterCollection
members, 5
public methods, 5
static methods, 5
OracleParameterCollection Class, 5
OracleParameterStatus enumeration type, 3.3.2.5.3, 5
OracleRefCursor, 3.6
OracleRefCursor Class
class description, 11
instance methods, 11
members, 11
populating from a REF CURSOR, 3.6.5
properties, 11
static methods, 11
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, 12
description, 12
members, 12
methods, 12
properties, 12
static fields, 12
static methods, 12
static operators, 12
type conversions, 12
OracleTimeStamp Structure
constructors, 12
description, 12
members, 12
methods, 12
properties, 12
static methods, 12
static operators, 12
static type conversions, 12
OracleTimeStampLTZ Structure
constructors, 12
description, 12
members, 12
methods, 12
properties, 12
static fields, 12
static methods, 12
static operators, 12
static type conversions, 12
OracleTimeStampTZ Structure
constructors, 12
description, 12
members, 12
methods, 12
properties, 12
static fields, 12
static methods, 12
static operators, 12
static type conversions, 12
OracleTransaction
members, 5
properties, 5
public methods, 5
static methods, 5
OracleTruncateException Class
class description, 13
constructors, 13
members, 13
methods, 13
properties, 13
static methods, 13
OracleTypeException Class
class description, 13
constructors, 13
members, 13
properties, 13
static methods, 13
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.8.3
class description, 6
constructors, 6
instance methods, 6
instance properties, 6
members, 6
static methods, 6

P

parameter binding, 3.3.2
password expiration, 3.1.8
performance, 3.3.3
array binding, 3.3.2.5
connection pooling, 3.1.3
fine-tuning FetchSize, 3.5.4.2
number of rows fetched, 3.5.4
Obtaining LOB Data, 3.5.3
PL/SQL Associative Array binding, 3.3.2.4
PL/SQL Index-By Tables, 3.3.2.4
PL/SQL language, 3.6
PL/SQL REF CURSOR, 3.6
PL/SQL REF CURSOR and OracleRefCursor, 3.6
PLSQLAssociativeArray, 5
populating an OracleDataReader from a REF CURSOR, 3.6.3
populating an OracleRefCursor from a REF CURSOR, 3.6.5
populating the DataSet from a REF CURSOR, 3.6.4
port number
defining listener, 3.9.2
porting
client application to .NET stored procedure, 4.3
preventing data loss, 3.10, 3.10.2
PrimaryKey property, 3.12
configuring, 3.12.2
privileged connections, 3.1.7
properties
ClientId property, 3.1.11
provider factory classes, 3.2, 3.2.3
provider independence, 3.2
proxy authentication, 3.1.9

R

RAC database
pool size attributes, 3.1.5.2
RAC environment, 3.1.5
readme.txt, 2.4
REF CURSOR
behavior of ExecuteScalar method, 3.6.7
obtaining, 3.6.2, 3.6.4
passing to stored procedure, 3.6.8
populating DataSet from, 3.6.4
populating from OracleDataReader, 3.6.3
registry entries, 3.15
release Oracle8i (8.1.7), 3.8.8.1
release Oracle9i(9.0.x), 3.8.8.1
Requery property, 3.11
round-trip, 3.3.2.5
RowSize property, 3.5.4.3
Runtime Connection Load Balancing, 3.1.5

S

Safe Type Mapping, 3.10
SafeMapping Property, 3.10.2
Samples, 1.4, 2.4
saving change using an XML document, 3.8.8.7
saving changes
using XML data, 3.8.8.2
schema metadata
custominzing metadata, 3.2.6
SchemaTable, 5
SelectCommand property, 3.6.4
session globalization parameters, 3.13.2.3
session globalization settings, 3.13.1.2
shema discovery
support, 3.2
simple application, 1.4
Size property, 3.3.2.4
SQL commands
unsupported, 4.2.3
Statement Caching
connection string attributes, 3.3.3.1
methods and properties, 3.3.3.3
Statement Cache Purge, 3.3.3
Statement Cache Size, 3.3.3
stored procedures and functions, 3.6.8, 4.1
Stream class, 3.7.2
support comparison
client application versus .NET stored procedure, 4.3
SYSDBA privileges, 3.1.7
SYSOPER privileges, 3.1.7
system requirements
Oracle Data Provider for .NET, 2.1
System.Data.Common, 3.2

T

table or view
special characters in, 3.8.8.4
TAF, 3.1.12
TAF callback support, 3.1.12
Temporary LOBs, 3.7.6
thread globalization settings, 3.13.2.2
thread-based globalization settings, 3.13.1.3
TraceFileName, 3.14.1.1
TraceLevel, 3.14.1.2
TraceOption, 3.14.1.3
Transaction object, 3.3.1
Transaction property, 3.3
transaction support, 4.2.2
transactions
commit, 3.8.8.10
Transparent Application Failover (TAF), 3.1.12
troubleshooting, 3.14
typed OracleDataReader accessors, 3.5.1

U

unique columns, 3.5.2, 3.5.3
unique constraint, 3.5.2, 3.5.3
unique index, 3.5.2, 3.5.3
UniqueConstraint, 3.12.2
uniqueness
in updating DataSet to database, 3.12
uniqueness in DataRows, 3.12.1
unsupported SQL commands, 4.2.3
updating
LOBs, 3.7.3
updating a DataSet obtained from a REF CURSOR, 3.6.6
updating LOBs using a DataSet, 3.7.3
updating LOBs using ODP.NET LOB objects, 3.7.5
updating LOBs using OracleCommand and OracleParameter, 3.7.4
updating without PrimaryKey and Constraints, 3.12.3
using FetchSize property, 3.5.4.1

V

Value property, 3.3.2.4
Virtual Private Database(VPD), 3.1.11
Visual Studio .Net
documentation, 2.3

W

web.config, 3.15
Windows registry, 2.4.1

X

XML
characters with special meaning, 3.8.6
data manipulation using, 3.8.8
XML data
saving changes using, 3.8.8.2
updating in OracleXmlType, 3.8.5
XML Database, 3.8
XML DB, 3.8
XML element name
case-sensitivity in, 3.8.8.5
XML Element Name to Column Name Mapping, 3.8.8.6
XML related classes, 6
XML related enumerations, 6
XML Support, 3.8
XMLQuery, 3.8.1
XMLTable, 3.8.1
XMLType column
as a .NET String, 3.8.4.1
fetching into the DataSet, 3.8.4.1
updating with OracleCommand, 3.8.4.2
XMLType columns
setting to NULL, 3.8.4.2.2
XQUERY, 3.8.1
XQuery language, 3.8.1