Index
A B C D E F G H I L M N O P R S T U V X
A
- array bind feature, 3.4.2.5
- Array Bind operations
-
- ArrayBindCount, 4
- ArrayBindIndex, 4
- ArrayBindSize, 4
- ArrayBindStatus, 4
- Array Binding
-
- error handling, 3.4.2.5.2
- array binding, 3.4.2.5
- ArrayBindCount property, 4
- ArrayBindIndex, 4
- ArrayBindSize, 4
- ArrayBindSize property, 3.4.2.4, 3.4.2.5.1
- ArrayBindStatus, 4
- ArrayBindStatus property, 3.4.2.4, 3.4.2.5.1
- assembly, 1.2
B
- behavior of ExecuteScalar method for REF CURSOR, 3.5.7
- BFILE, 3.6
- 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.6
C
- C#, 4
- callback support, 3.1.7
- case-sensitivity
-
- column name mapping, 3.12.7.5
- Class Inheritance, 4
- client globalization settings, 3.7.1.1, 3.7.2.1
- CLOB, 3.6
- CollectionType property, 3.4.2.4
- column data
-
- special characters in, 3.12.7.3
- commits
-
- changes to XML data, 3.12.7.9
- connection dependency, 3.12.2
- Connection Lifetime, 3.1.2
- connection pooling, 3.1.2
- connection pooling example, 3.1.2
- Connection property, 3.6
- connection string attributes, 4
- Connection Timeout, 3.1.2
- ConnectionString, 3.1.2
- ConnectionString attributes, 3.1.2
-
- Connection Lifetime, 3.1.1
- Connection Timeout, 3.1.1
- Decr Pool Size, 3.1.1
- Incr Pool Size, 3.1.1
- Max Pool Size, 3.1.1
- Min Pool Size, 3.1.1
- Pooling, 3.1.1
- Constraints property, 3.8
-
- configuring, 3.8.2
- controlling query reexecution, 3.10
D
- data loss, 3.9
- data manipulation
-
- using XML, 3.12.7
- database
-
- changes to, 3.12.7
- DataSet, 3.6.1
-
- updating, 3.5.6
- dataset
-
- updating to database, 3.8
- DataTable, 3.8.2
- Datatable properties, 3.8
- DbType
-
- inference, 3.4.2.3
- debug tracing, 3.11
-
- registry settings, 3.11.1
- Decr Pool Size, 3.1.2
- default mapping
-
- improving, 3.12.7.6.3
- documentation, 2.3
- Dynamic Help, Visual Studio .Net
-
- documentation, 2.2
E
- error handling
-
- Array Binding, 3.4.2.5.2
- example
-
- connection pooling, 3.1.2
- ExecuteNonQuery, 3.5.5
- ExecuteScalar method, 3.5.7
F
- FailoverEvent Enumeration, 4
- FailoverReturnCode Enumeration, 4
- FailoverType Enumeration, 4
- features, 3
- FetchSize property
-
- fine-tuning, 3.3.4.2
- setting at design time, 3.3.4.3.1
- setting at runtime, 3.3.4.3.2
- using, 3.3.4.1
G
- Global Assembly Cache (GAC), 2.2
- globalization settings, 3.7.1
-
- client, 3.7.1.1
- session, 3.7.1.2
- thread-based, 3.7.1.3
- globalization support, 3.7
- globalization-sensitive operations, 3.7.2
- grid-computing, Preface
- grids, Preface
H
- Handling Date and Time Format
-
- manipulating data in XML, 3.12.7.1
- retrieving queries in XML, 3.12.6.1
I
- improving default mapping, 3.12.7.6.3
- Incr Pool Size, 3.1.2
- 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, 3.3.3
- InitialLONGFetchSize, 3.3.2, 3.3.2
- input binding
-
- XMLType column, 3.12.3.2.1
- installation, 2.2
-
- ODP.NET, 2.2
- Oracle Data Provider for .NET, 2.2
- Integrated Help, 2.2
- Interface Inheritance, 4
- interference in OracleParameter class, 3.4.2.3
- introduction, overview, 1.1
- InvalidCastException, 3.3.1.1
L
- large binary datatypes, 3.6
- large character datatypes, 3.6
- LOB Connection property, 3.6
- LOBs
-
- temporary, 3.6.4
- updating, 3.6.2, 3.6.3
- LOBs updating, 3.6.1
- LONG and LONG RAW datatypes, 3.6
M
- Max Pool Size, 3.1.2
- metadata, 3.8.3
- Microsoft Transaction Server, 2.1
- Min Pool Size, 3.1.2
- MTS, 2.1
- Multiple Oracle Homes, Preface
- multiple tables
-
- changes to, 3.12.7.8
N
- native XML support, 3.12
- NCLOB, 3.6
- .NET Framework datatype, 3.2
- .NET Stream class, 3.6
- .NET type accessors, 3.3.1.1
- .NET Types
-
- inference, 3.4.2.3
- NULL values
-
- retrieving from column, 3.12.6.7
- number of rows fetched in round-trip
-
- controlling, 3.3.4
O
- object-relational data, 3.12.6.6
-
- saving changes from XML data, 3.12.7.7
- obtaining a REF CURSOR, 3.5.2, 3.5.4
- Obtaining an OracleRefCursor, 3.5.1
- Obtaining Data From an OracleDataReader, 3.3
- Obtaining LOB data
-
- InitialLOBFetchSize, 3.3.3
- obtaining LONG and LONG RAW Data, 3.3.2, 3.3.2
- ODP.NET
-
- installing, 2.2, 2.2
- ODP.NET LOB classes, 3.6
- ODP.NET Type accessors, 3.3.1.2
- ODP.NET Type classes, 3.2
- ODP.NET Type Exceptions, 5
- ODP.NET Type Structures, 5
- ODP.NET Type structures, 3.2
- ODP.NET Types, 3.2
- ODP.NET Types Overview, 3.2
- ODP.NET XML Support, 3.12
- operating system authentication, 3.1.3
- Oracle 8.1.7, 3.12
-
- saving changes to, 3.12.7.6.1
- Oracle Data Provider for .NET
-
- installing, 2.2
- system requirements, 2.1
- Oracle native types, 3.2
-
- supported by ODP.NET, 3.3.1.1
- Oracle Services for Microsoft Transaction Server, 2.1
- Oracle Universal Installer (OUI), 2.2
- Oracle XDK, 3.12
- ORACLE_BASEORACLE_HOMEbin directory, 2.3
- Oracle9i
-
- saving changes to, 3.12.7.6.2
- Oracle9i XML Developer's Kits, 3.12
- OracleBFile
-
- constructors, 5
- instance methods, 5
- instance properties, 5
- members, 5
- static fields, 5
- static methods, 5
- OracleBFile Class, 5
- OracleBinary
-
- constructor, 5
- instance methods, 5
- members, 5
- properties, 5
- static fields, 5
- static methods, 5
- static operators, 5
- static type conversion operators, 5
- OracleBinary Structure, 5
- OracleBlob
-
- constructors, 5
- instance methods, 5
- instance properties, 5
- members, 5
- static fields, 5
- static methods, 5
- OracleBlob Class, 5
- OracleClob
-
- constructors, 5
- instance methods, 5
- instance properties, 5
- members, 5
- static fields, 5
- static methods, 5
- OracleClob Class, 5
- OracleCollectionType Enumeration, 4
- OracleCommand
-
- ArrayBindCount, 4
- constructors, 4
- FetchSize property, 3.3.4.1
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleCommand ArrayBindCount property, 3.4.2.5
- OracleCommand Class, 4
- OracleCommand object, 3.4
- OracleCommand Transaction object, 3.4.1
- OracleCommandBuilder, 3.8.3
-
- constructors, 4
- event delegates, 4
- events, 4
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- updating dataset, 3.8
- OracleCommandBuilder Class, 4
- OracleConnection
-
- constructors, 4
- event delegates, 4
- events, 4
- members, 4
- obtaining a reference, 3.12.2
- properties, 4
- public methods, 4
- static methods, 4
- OracleConnection Class, 4
- Oracle.DataAccess.Client, 4
- Oracle.DataAccesss.dll assembly, 2.3
- OracleDataAdapter, 3.9
-
- constructors, 4
- event delegates, 4
- events, 4
- FillSchema, 3.8.2, 3.8.3
- members, 4
- properties, 4
- public methods, 4
- Requery property, 3.10
- SafeMapping Property, 3.9.2
- SelectCommand, 3.8.1, 3.8.3
- static methods, 4
- OracleDataAdapter Class, 4
- OracleDataAdapter Safe Type Mapping, 3.9
- OracleDataReader, 3.3
-
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleDataReader Class, 4
- OracleDataReader SchemaTable, 4
- OracleDate
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static fields, 5
- static methods, 5
- static operators, 5
- static type conversions, 5
- OracleDate Structure, 5
- OracleDbType
-
- inference, 3.4.2.3
- OracleDbType Enumeration Type, 4
- OracleDbType enumeration type, 3.4.2.2
- OracleDbType enumeration values, 3.4.2.3
- OracleDecimal
-
- constructors, 5
- instance methods, 5
- members, 5
- properties, 5
- static comparison methods, 5
- static comparison operators, 5
- static logarithmic methods, 5
- static manipulation methods, 5
- static operators, .NET Type to OracleDecimal, 5
- static operators, OracleDecimal to .NET, 5
- static trignonmetric methods, 5
- OracleDecimal Structure, 5
- OracleError
-
- ArrayBindIndex, 4
- members, 4
- methods, 4
- properties, 4
- static methods, 4
- OracleError Class, 4
- OracleErrorCollection
-
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleErrorCollection Class, 4
- OracleException
-
- members, 4
- methods, 4
- properties, 4
- static methods, 4
- OracleException Class, 4
- OracleFailoverEventArgs
-
- members, 4
- properties, 4
- public methods, 4
- OracleFailoverEventHandler Delegate, 4
- OracleGlobalization
-
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleInfoMessageEventArgs
-
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleInfoMessageEventHandler Delegate, 4
- OracleIntervalDS
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static methods, 5
- static operators, 5
- type conversions, 5
- OracleIntervalDS Structure, 5
- OracleIntervalYM
-
- constructors, 5
- members, 5
- methods, 5, 5
- properties, 5
- static fields, 5
- static operators, 5
- type conversions, 5
- OracleIntervalYM Structure, 5
- OracleNullValueException
-
- constructors, 5
- members, 5
- methods, 5, 5
- properties, 5
- OracleNullValueException Class, 5
- OracleParameter
-
- ArrayBindSize, 4
- ArrayBindStatus, 4
- constructors, 4
- inferences of types, 3.4.2.3
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleParameter array bind feature, 3.4.2.5
- OracleParameter array bind properties, 3.4.2.5.1
- OracleParameter Class, 4, 4
- OracleParameter class
-
- Value, 3.4.2.3.3
- 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, 4
- public methods, 4
- static methods, 4
- OracleParameterCollection Class, 4
- OracleParameterStatus enumeration type, 3.4.2.5.3, 4
- OracleReader
-
- FetchSize property, 3.3.4.1
- OracleRefCursor, 3.5
-
- instance methods, 5
- members, 5
- populating, 3.5.5
- properties, 5
- static methods, 5
- OracleRefCursor Class, 5
- OracleRowUpdatedEventArgs
-
- constructor, 4
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleRowUpdatedEventArgs Class, 4
- OracleRowUpdatedEventHandler Delegate, 4
- OracleRowUpdatingEventArgs
-
- constructor, 4
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleRowUpdatingEventArgs Class, 4
- OracleRowUpdatingEventHandler Delegate, 4
- OracleString
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static fields, 5
- static methods, 5
- static operators, 5
- type conversions, 5
- OracleString Structure, 5
- OracleTimeStamp
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static methods, 5
- static operators, 5
- static type conversions, 5
- OracleTimeStamp Structure, 5
- OracleTimeStampLTZ
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static fields, 5
- static methods, 5
- static type conversions, 5
- static type operators, 5
- OracleTimeStampLTZ Structure, 5
- OracleTimeStampTZ
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static fields, 5
- static methods, 5
- static operators, 5
- static type conversions, 5
- OracleTimeStampTZ Structure, 5
- OracleTransaction
-
- members, 4
- properties, 4
- public methods, 4
- static methods, 4
- OracleTruncateException
-
- constructors, 5
- members, 5
- methods, 5
- properties, 5
- static methods, 5
- OracleTruncateException Class, 5
- OracleTypeException
-
- constructors, 5
- members, 5
- properties, 5
- static methods, 5
- OracleTypeException Class, 5
- OracleXmlPropertyCollection Class, 4
- OracleXmlStream Class, 5
- OracleXmlType, 3.12.2
- OracleXmlType Class, 5
- Overview of ODP.NET Types, 5
- Overview of Oracle Data Provider Classes, 4
P
- parameter binding, 3.4.2
- password expiration, 3.1.5
- performance
-
- array binding, 3.4.2.5
- connection pooling, 3.1.2
- fine-tuning FetchSize, 3.3.4.2
- number of rows fetched, 3.3.4
- Obtaining LOB Data, 3.3.3
- PL/SQL Associative Array binding, 3.4.2.4
- PL/SQL language, 3.5
- PL/SQL REF CURSOR, 3.5
- PL/SQL REF CURSOR and OracleRefCursor, 3.5
- PLSQLAssociativeArray, 4
- Pooling, 3.1.2
- 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
- preventing data loss, 3.9, 3.9.2
- PrimaryKey property, 3.8
-
- configuring, 3.8.2
- privileged connections, 3.1.4
- proxy authentication, 3.1.6
R
- readme.txt, 2.3
- REF CURSOR
-
- behavior of ExecuteScalar method for, 3.5.7
- obtaining, 3.5.2, 3.5.4
- populating DataSet from, 3.5.4
- populating from OracleDataReader, 3.5.3
- Requery property, 3.10
- round-trip, 3.4.2.5
- RowSize property, 3.3.4.3
S
- Safe Type Mapping, 3.9
- SafeMapping Property, 3.9.2
- Samples, 1.3, 2.3
- saving changes
-
- to Oracle 8.1.7, 3.12.7.6.1
- to Oracle9i, 3.12.7.6.2
- using XML data, 3.12.7.2
- SchemaTable, 4
- session globalization parameters, 3.7.2.3
- session globalization settings, 3.7.1.2
- Size property, 3.4.2.4
- special characters
-
- in column data, 3.12.7.3
- in table or view, 3.12.7.4
- special characters in XML, 3.12.5
- Stream class, 3.6
- Syntax Used
-
- described, 4
- SYSDBA privileges, 3.1.4
- SYSOPER privileges, 3.1.4
- system requirements, 2.1
-
- Oracle Data Provider for .NET, 2.1
T
- table or view
-
- special characters in, 3.12.7.4
- TAF, 3.1.7
- TAF callback support, 3.1.7
- Temporary LOBs, 3.6.4
- thread globalization settings, 3.7.2.2
- thread-based globalization settings, 3.7.1.3
- TraceFileName, 3.11.1.1
- TraceLevel, 3.11.1.2
- TraceOption, 3.11.1.3
- Transaction object, 3.4.1
- Transparent Application Failover (TAF), 3.1.7
- troubleshooting, 3.11
- Typed OracleDataReader Accessors, 3.3.1
U
- unique columns, 3.3.2, 3.3.3
- unique constraint, 3.3.2, 3.3.3
- unique index, 3.3.2, 3.3.3
- UniqueConstraint, 3.8.2
- uniqueness
-
- in updating dataset to database, 3.8
- uniqueness in DataRows, 3.8.1
- updating
-
- LOBs, 3.6.1
- updating a DataSet Obtained from a REF CURSOR, 3.5.6
- updating LOBs using a DataSet, 3.6.1
- updating LOBs using ODP.NET LOB objects, 3.6.3
- updating LOBs using OracleCommand and OracleParameter, 3.6.2
- updating without PrimaryKey and Constraints, 3.8.3
- using FetchSize property, 3.3.4.1
V
- Value property, 3.4.2.4
X
- XLMType columns
-
- setting to NULL, 3.12.3.2.2
- XML
-
- data manipulation using, 3.12.7
- special characters, 3.12.5
- XML data
-
- saving changes using, 3.12.7.2
- updating in OracleXmlType, 3.12.4
- XML Database, 3.12
- XML DB, 3.12
- XML element name
-
- case-sensitivity in, 3.12.7.5
- XML Element Name to Column Name Mapping, 3.12.7.6
- XML Support, 3.12
- XMLType column
-
- as a .NET String, 3.12.3.1
- fetching into the DataSet, 3.12.3.1
- updating with OracleCommand, 3.12.3.2