Skip Headers

Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1)

Part Number B10117-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
View PDF

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