Index
A B C D E F G H I L M N O P R S T U V X
A
- ADO, 1.2
- ADO.NET, 1.2
- array bind
-
- OracleParameter, 3.2.2.5.1
- array bind operations, 3.2.2.5
-
- ArrayBindCount, 5
- ArrayBindIndex, 5
- ArrayBindSize, 5
- ArrayBindStatus, 5
- error handling, 3.2.2.5.2
- array binding, 3.2.2.5
- ArrayBindCount property, 5
- ArrayBindIndex property, 5
- ArrayBindSize property, 3.2.2.4, 3.2.2.5.1, 5
- ArrayBindStatus property, 3.2.2.4, 3.2.2.5.1, 5
- assembly, 1.3
-
- ODP.NET, 1.3
B
- behavior of ExecuteScalar method for REF CURSOR, 3.5.7
- BFILE, 3.6
- BINARY_DOUBLE, 3.2.2.1
- BINARY_FLOAT, 3.2.2.1
- binding, 3.2.2
-
- PL/SQL Associative Array, 3.2.2.4
- BLOB, 3.6
C
- callback support, 3.1.10
- case-sensitivity
-
- column name mapping, 3.7.7.5
- change notification
-
- ODP.NET support, 3.8.2
- change notification, Database Change Notification, 7
- characters with special meaning
-
- in column data, 3.7.7.3
- in table or view, 3.7.7.4
- characters with special meaning in XML, 3.7.5
- client applications, 1.1.1
- client globalization settings, 3.12.1.1, 3.12.2.1
- client identifier, 3.1.9
- CLOB, 3.6
- CLR, 1.1.3
- CollectionType property, 3.2.2.4
- column data
-
- special characters in, 3.7.7.3
- CommandBehavior.SequentialAccess, 3.4.2
- commit transactions
-
- changes to XML data, 3.7.7.9
- connection dependency, 3.7.2
- connection pooling, 3.1.3
-
- example, 3.1.3
- for RAC database, 3.1.4
- Connection property, 3.6.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
- 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.8
- Proxy User Id, 3.1.1, 3.1.8
- 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.11
-
- configuring, 3.11.2
- controlling query reexecution, 3.10
D
- data loss, 3.9
- data manipulation
-
- using XML, 3.7.7
- database
-
- changes to, 3.7.7
- Database Change Notification
-
- best practices, 3.8.5
- performance considerations, 3.8.5
- database change notification, 3.8, 3.8.1
-
- ODP.NET support, 3.8.2
- DataSet, 3.6.3
-
- populating, 3.5.4
- populating from a REF CURSOR, 3.5.4
- updating, 3.5.6
- updating to database, 3.11
- DataTable, 3.11.2
- Datatable properties, 3.11
- DbType
-
- inference, 3.2.2.3
- debug tracing, 3.13
-
- registry settings, 3.13.1
- default mapping
-
- improving, 3.7.7.6.3
- documentation, 2.3
-
- .NET, 1.1
- dynamic help, 1.1.1, 2.2
E
- enumeration type
-
- OracleDbType, 3.2.2.2
- error handling, 3.2.2.5.2
- example
-
- connection pooling, 3.1.3
- ExecuteNonQuery method, 3.5.5
- ExecuteScalar method, 3.5.7
- explicit user connections, 4
F
- failover, 3.1.10
-
- registering an event handler, 3.1.10
- FailoverEvent Enumeration
-
- description, 9
- FailoverReturnCode Enumeration
-
- description, 9
- FailoverType Enumeration
-
- description, 9
- FAN, 3.1.4
- Fast Application Notification (FAN), 3.1.4
- features, 3
-
- new, Preface
- FetchSize property
-
- fine-tuning, 3.4.4.2
- setting at design time, 3.4.4.3.1
- setting at runtime, 3.4.4.3.2
- using, 3.4.4.1
- file locations, 2.3
G
- Global Assembly Cache (GAC), 2.2
- globalization settings, 3.12.1
-
- client, 3.12.1.1
- session, 3.12.1.2
- thread-based, 3.12.1.3
- globalization support, 3.12
- globalization-sensitive operations, 3.12.2
- Grid environment, 3.1.4
- grid-computing, Preface
- grids, Preface
- GUI access to ODP.NET, 1.1.2
H
- HA Events, 3.1.1, 3.1.4
-
- debug tracing information, 3.13.1.2
- handling date and time format
-
- manipulating data in XML, 3.7.7.1
- retrieving queries in XML, 3.7.6.1
I
- implicit database connection, 4, 4.2.1, 4.2.2, 5
- improving default mapping, 3.7.7.6.3
- inference from Value property, 3.2.2.3.3
- inference of DbType and OracleDbType from Value, 3.2.2.3.3
- inference of DbType from OracleDbType, 3.2.2.3.1
- inference of OracleDbType from DbType, 3.2.2.3.2
- inference of types, 3.2.2.3
- InitialLOBFetchSize property, 3.4.3
- InitialLONGFetchSize property, 3.4.2
- input binding
-
- XMLType column, 3.7.3.2.1
- installation, 2.2
-
- Oracle Data Provider for .NET, 2.2
- integrated help, 2.2
- interference in OracleParameter class, 3.2.2.3
- introduction, overview, 1.2
- invalidation message, 3.8.1
-
- ensuring persistency of, 3.8.2
- InvalidCastException, 3.4.1.1
L
- large binary datatypes, 3.6.1
- large character datatypes, 3.6.1
- limitations and restrictions, 4.2
- Load Balancing, 3.1.1, 3.1.4
-
- debug tracing information, 3.13.1.2
- LOB Connection property, 3.6.2
- LOBs
-
- temporary, 3.6.6
- updating, 3.6.4, 3.6.5
- LOBs updating, 3.6.3
- LONG and LONG RAW datatypes, 3.6.1
M
- metadata, 3.11.3
- 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.8.2
- Multiple Oracle Homes, Preface
- multiple tables
-
- changes to, 3.7.7.8
N
- namespace
-
- Oracle.DataAccess.Types, 1.3.2
- native XML support, 3.7
- NCLOB, 3.6
- .NET Framework datatype, 3.3
- .NET languages, 1.1.2
- .NET products and documentation, 1.1
- .NET stored procedures and functions, 4.1
- .NET Stream class, 3.6.2
- .NET type accessors, 3.4.1.1
- .NET Types
-
- inference, 3.2.2.3
- notification framework, 3.8.1
- notification information
-
- retrieving, 3.8.2
- notification process
-
- flow, 3.8.3
- notification registration, 3.8.2, 3.8.2
-
- requirements of, 3.8.3
- NULL values
-
- retrieving from column, 3.7.6.7
- number of rows fetched in round-trip
-
- controlling, 3.4.4
O
- object-relational data, 3.7.6.6
-
- saving changes from XML data, 3.7.7.7
- obtaining a REF CURSOR, 3.5.2, 3.5.4
- obtaining an OracleRefCursor, 3.5.1
- obtaining data from an OracleDataReader, 3.4
- obtaining LOB data
-
- InitialLOBFetchSize property, 3.4.3
- obtaining LONG and LONG RAW Data, 3.4.2, 3.4.2
- OCI
-
- statement caching, 3.2.3
- ODP.NET
-
- installing, 2.2
- ODP.NET LOB classes, 3.6
- ODP.NET Type accessors, 3.4.1.2
- ODP.NET Type classes, 3.3
- ODP.NET Type exceptions, 12
- ODP.NET Type structures, 3.3, 11
- ODP.NET Types, 3.3
-
- overview, 3.3
- 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.7
- OnChangedEventArgs Class
-
- instance properties, 7
- members, 7
- static fields, 7
- static methods, 7
- OnChangeEventHandler Delegate
-
- description, 7
- operating system authentication, 3.1.5
- Oracle 8.1.7, 3.7
-
- saving changes to, 3.7.7.6.1
- Oracle Call Interface
-
- statement caching, 3.2.3
- Oracle Data Provider for .NET
-
- installing, 2.2
- 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.9
- Oracle native types, 3.3
-
- supported by ODP.NET, 3.4.1.1
- Oracle Services for Microsoft Transaction Server, 2.1
- Oracle Universal Installer (OUI), 2.2
- Oracle Virtual Private Database (VPD), 3.1.9
- Oracle XDK, 3.7
- ORACLE_BASEORACLE_HOMEbin directory, 2.3
- Oracle9i
-
- saving changes to, 3.7.7.6.2
- Oracle9i XML Developer's Kits, 3.7
- OracleBFile Class
-
- class description, 10
- constructors, 10
- instance methods, 10
- instance properties, 10
- members, 10
- static fields, 10
- static methods, 10
- OracleBinary Structure
-
- constructor, 11
- description, 11
- instance methods, 11
- members, 11
- properties, 11
- static fields, 11
- static methods, 11
- static operators, 11
- static type conversion operators, 11
- OracleBlob Class
-
- class description, 10
- constructors, 10
- instance methods, 10
- instance properties, 10
- members, 10
- static fields, 10
- static methods, 10
- OracleClob Class
-
- class description, 10
- constructors, 10
- instance methods, 10
- instance properties, 10
- members, 10
- static fields, 10
- static methods, 10
- OracleCollectionType Enumeration, 5
- OracleCommand
-
- ArrayBindCount, 5
- constructors, 5
- InitialLOBFetchSize property, 3.4.3
- InitialLONGFetchSize property, 3.4.2
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- Transaction property, 3.2
- OracleCommand Class, 5
-
- ArrayBindCount property, 3.2.2.5
- ExecuteScalar method, 3.5.7
- FetchSize property, 3.4.4.1
- RowSize property, 3.4.4.3
- OracleCommand object, 3.2
- OracleCommand properties
-
- ArrayBindCount, 3.2.2.5
- OracleCommand Transaction object, 3.2.1
- OracleCommandBuilder
-
- static methods, 5
- OracleCommandBuilder Class, 3.11.3, 5
-
- constructors, 5
- events, 5
- members, 5
- properties, 5
- public methods, 5
- updating dataset, 3.11
- OracleConnection
-
- ClientId property, 3.1.9
- constructors, 5
- events, 5
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- OracleConnection Class, 5
-
- obtaining a reference, 3.7.2
- Oracle.DataAccess.Client namespace, 1.3
- Oracle.DataAccess.dll, 1.3
- Oracle.DataAccesss.dll assembly, 2.3
- Oracle.DataAccess.Types namespace, 1.3, 1.3.2
- OracleDataAdapter, 3.9
-
- constructors, 5
- events, 5
- members, 5
- properties, 5
- public methods, 5
- SafeMapping Property, 3.9.2
- SelectCommand property, 3.5.4
- static methods, 5
- OracleDataAdapter Class, 5
-
- FillSchema method, 3.11.3
- SelectCommand property, 3.11.3
- OracleDataAdapter class
-
- FillSchema method, 3.11.2
- Requery property, 3.10
- SelectCommand property, 3.11.1
- OracleDataAdapter Safe Type Mapping, 3.9
- OracleDataReader, 3.4, 3.4.2
-
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- typed accessors, 3.4.1
- OracleDataReader Class, 5
-
- FetchSize property, 3.4.4.1
- populating, 3.5.3
- OracleDataReader SchemaTable, 5
- OracleDate Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static fields, 11
- static methods, 11
- static operators, 11
- static type conversions, 11
- OracleDbType
-
- inference, 3.2.2.3
- OracleDbType enumeration, 3.2.2.3
- OracleDbType enumeration type, 3.2.2.2, 5
- OracleDecimal Structure
-
- constructors, 11
- description, 11
- instance methods, 11
- members, 11
- properties, 11
- static comparison methods, 11
- static comparison operators, 11
- static logarithmic methods, 11
- static manipulation methods, 11
- static operators, .NET Type to OracleDecimal, 11
- static operators, OracleDecimal to .NET, 11
- static trignonmetric methods, 11
- OracleDependency Class
-
- change notification, 3.8.1
- class description, 7
- constructors, 7
- database change notification, 3.8
- events, 7
- instance methods, 7
- instance properties, 7
- members, 7
- static fields, 7
- static methods, 7
- OracleError
-
- ArrayBindIndex, 5
- members, 5
- methods, 5
- properties, 5
- static methods, 5
- OracleError Class, 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, 9
- properties, 9
- public methods, 9
- OracleFailoverEventHandler Delegate
-
- description, 9
- OracleGlobalization Class
-
- class description, 8
- members, 8
- properties, 8
- public methods, 8
- OracleInfoMessageEventArgs
-
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- OracleInfoMessageEventHandler Delegate, 5
- OracleIntervalDS Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static methods, 11
- static operators, 11
- type conversions, 11
- OracleIntervalYM Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11, 11
- properties, 11
- static fields, 11
- static operators, 11
- type conversions, 11
- OracleNotificationEventArgs Class
-
- change notification, 3.8.1
- class description, 7
- instance methods, 7
- OracleNotificationInfo Enumeration
-
- description, 7
- OracleNotificationRequest Class
-
- change notification, 3.8.1
- class description, 7
- database change notification, 3.8
- instance methods, 7
- instance properties, 7
- members, 7
- static methods, 7
- OracleNotificationSource Enumeration
-
- description, 7
- OracleNotificationType Enumeration
-
- description, 7
- OracleNullValueException Class
-
- class description, 12
- constructors, 12
- members, 12
- methods, 12, 12
- properties, 12
- OracleParameter
-
- array bind properties, 3.2.2.5.1
- ArrayBindSize property, 3.2.2.5.1, 5
- ArrayBindStatus property, 3.2.2.5.1, 5
- constructors, 5
- inferences of types, 3.2.2.3
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- OracleParameter array bind feature, 3.2.2.5
- OracleParameter Class, 5, 5
-
- Value, 3.2.2.3.3
- OracleParameter object, 3.2.2
-
- OracleDbType enumerated values, 3.2.2.2
- OracleParameter property
-
- ArrayBindSize, 3.2.2.4
- ArrayBindStatus, 3.2.2.4
- CollectionType, 3.2.2.4
- Size, 3.2.2.4
- Value, 3.2.2.4
- OracleParameterCollection
-
- members, 5
- public methods, 5
- static methods, 5
- OracleParameterCollection Class, 5
- OracleParameterStatus enumeration type, 3.2.2.5.3, 5
- OracleRefCursor, 3.5
- OracleRefCursor Class
-
- class description, 10
- instance methods, 10
- members, 10
- populating from a REF CURSOR, 3.5.5
- properties, 10
- static methods, 10
- 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, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static fields, 11
- static methods, 11
- static operators, 11
- type conversions, 11
- OracleTimeStamp Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static methods, 11
- static operators, 11
- static type conversions, 11
- OracleTimeStampLTZ Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static fields, 11
- static methods, 11
- static operators, 11
- static type conversions, 11
- OracleTimeStampTZ Structure
-
- constructors, 11
- description, 11
- members, 11
- methods, 11
- properties, 11
- static fields, 11
- static methods, 11
- static operators, 11
- static type conversions, 11
- OracleTransaction
-
- members, 5
- properties, 5
- public methods, 5
- static methods, 5
- OracleTruncateException Class
-
- class description, 12
- constructors, 12
- members, 12
- methods, 12
- properties, 12
- static methods, 12
- OracleTypeException Class
-
- class description, 12
- constructors, 12
- members, 12
- properties, 12
- static methods, 12
- 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.7.2
-
- class description, 6
- constructors, 6
- instance methods, 6
- instance properties, 6
- members, 6
- static methods, 6
P
- parameter binding, 3.2.2
- password expiration, 3.1.7
- performance, 3.2.3
-
- array binding, 3.2.2.5
- connection pooling, 3.1.3
- fine-tuning FetchSize, 3.4.4.2
- number of rows fetched, 3.4.4
- Obtaining LOB Data, 3.4.3
- PL/SQL Associative Array binding, 3.2.2.4
- PL/SQL Index-By Tables, 3.2.2.4
- PL/SQL language, 3.5
- PL/SQL REF CURSOR, 3.5
- PL/SQL REF CURSOR and OracleRefCursor, 3.5
- PLSQLAssociativeArray, 5
- populating an OracleDataReader from a REF CURSOR, 3.5.3
- populating an OracleRefCursor from a REF CURSOR, 3.5.5
- populating the DataSet from a REF CURSOR, 3.5.4
- port number
-
- defining listener, 3.8.2
- porting
-
- client application to .NET stored procedure, 4.3
- preventing data loss, 3.9, 3.9.2
- PrimaryKey property, 3.11
-
- configuring, 3.11.2
- privileged connections, 3.1.6
- properties
-
- ClientId property, 3.1.9
- proxy authentication, 3.1.8
R
- RAC database
-
- pool size attributes, 3.1.4.2
- RAC environment, 3.1.4
- readme.txt, 2.3
- REF CURSOR
-
- behavior of ExecuteScalar method, 3.5.7
- obtaining, 3.5.2, 3.5.4
- passing to stored procedure, 3.5.8
- populating DataSet from, 3.5.4
- populating from OracleDataReader, 3.5.3
- release Oracle8i (8.1.7), 3.7.7.1
- release Oracle9i(9.0.x), 3.7.7.1
- Requery property, 3.10
- round-trip, 3.2.2.5
- RowSize property, 3.4.4.3
- Runtime Connection Load Balancing, 3.1.4
S
- Safe Type Mapping, 3.9
- SafeMapping Property, 3.9.2
- Samples, 1.4, 2.3
- saving changes
-
- to Oracle 8.1.7, 3.7.7.6.1
- to Oracle9i, 3.7.7.6.2
- using XML data, 3.7.7.2
- SchemaTable, 5
- SelectCommand property, 3.5.4
- session globalization parameters, 3.12.2.3
- session globalization settings, 3.12.1.2
- simple application, 1.4
- Size property, 3.2.2.4
- SQL commands
-
- unsupported, 4.2.3
- Statement Caching
-
- connection string attributes, 3.2.3.1
- methods and properties, 3.2.3.3
- Statement Cache Purge, 3.2.3
- Statement Cache Size, 3.2.3
- stored procedures and functions, 3.5.8, 4.1
- Stream class, 3.6.2
- support comparison
-
- client application versus .NET stored procedure, 4.3
- SYSDBA privileges, 3.1.6
- SYSOPER privileges, 3.1.6
- system requirements
-
- Oracle Data Provider for .NET, 2.1
T
- table or view
-
- special characters in, 3.7.7.4
- TAF, 3.1.10
- TAF callback support, 3.1.10
- Temporary LOBs, 3.6.6
- thread globalization settings, 3.12.2.2
- thread-based globalization settings, 3.12.1.3
- TraceFileName, 3.13.1.1
- TraceLevel, 3.13.1.2
- TraceOption, 3.13.1.3
- Transaction object, 3.2.1
- Transaction property, 3.2
- transaction support, 4.2.2
- transactions
-
- commit, 3.7.7.9
- Transparent Application Failover (TAF), 3.1.10
- troubleshooting, 3.13
- typed OracleDataReader accessors, 3.4.1
U
- unique columns, 3.4.2, 3.4.3
- unique constraint, 3.4.2, 3.4.3
- unique index, 3.4.2, 3.4.3
- UniqueConstraint, 3.11.2
- uniqueness
-
- in updating DataSet to database, 3.11
- uniqueness in DataRows, 3.11.1
- unsupported SQL commands, 4.2.3
- updating
-
- LOBs, 3.6.3
- updating a DataSet obtained from a REF CURSOR, 3.5.6
- updating LOBs using a DataSet, 3.6.3
- updating LOBs using ODP.NET LOB objects, 3.6.5
- updating LOBs using OracleCommand and OracleParameter, 3.6.4
- updating without PrimaryKey and Constraints, 3.11.3
- using FetchSize property, 3.4.4.1
V
- Value property, 3.2.2.4
- Virtual Private Database(VPD), 3.1.9
- Visual Studio .Net
-
- documentation, 2.2
X
- XML
-
- characters with special meaning, 3.7.5
- data manipulation using, 3.7.7
- XML data
-
- saving changes using, 3.7.7.2
- updating in OracleXmlType, 3.7.4
- XML Database, 3.7
- XML DB, 3.7
- XML element name
-
- case-sensitivity in, 3.7.7.5
- XML Element Name to Column Name Mapping, 3.7.7.6
- XML related classes, 6
- XML related enumerations, 6
- XML Support, 3.7
- XMLType column
-
- as a .NET String, 3.7.3.1
- fetching into the DataSet, 3.7.3.1
- updating with OracleCommand, 3.7.3.2
- XMLType columns
-
- setting to NULL, 3.7.3.2.2