Skip Headers

Oracle® Data Provider for .NET Developer's Guide
10g Release 1 (10.1.0.3)
Part No. B14164-01
  Go To Table Of Contents
Contents

Previous  

Index

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

A

array bind operations, 3.2.2.5
ArrayBindCount, 4
ArrayBindIndex, 4
ArrayBindSize, 4
ArrayBindStatus, 4
ArrayBindCount property, 4
ArrayBindIndex property, 4
ArrayBindSize property, 3.2.2.4, 3.2.2.5.1, 4
ArrayBindStatus property, 3.2.2.4, 3.2.2.5.1, 4
assembly, 1.2

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.7
case-sensitivity
column name mapping, 3.7.7.5
client globalization settings, 3.11.1.1, 3.11.2.1
CLOB, 3.6
CollectionType property, 3.2.2.4
column data
special characters in, 3.7.7.3
commits
changes to XML data, 3.7.7.9
connection dependency, 3.7.2
Connection Lifetime attribute, 3.1.2
connection pooling, 3.1.2
example, 3.1.2
Connection property, 3.6.2
connection string attributes, 4
Connection Timeout attribute, 3.1.2
ConnectionString attributes, 3.1.2
Connection Lifetime, 3.1.1, 3.1.2.1
Connection Timeout, 3.1.1, 3.1.2.1
Data Source, 3.1.1
DBA Privilege, 3.1.1
Decr Pool Size, 3.1.1, 3.1.1, 3.1.2.1
Enlist, 3.1.1
Incr Pool Size, 3.1.1, 3.1.1, 3.1.2.1
Max Pool Size, 3.1.1, 3.1.2.1
Min Pool Size, 3.1.1, 3.1.1, 3.1.2.1
Password, 3.1.1
Persist Security Info, 3.1.1
Pooling, 3.1.1, 3.1.2.1
Proxy Password, 3.1.1
Proxy User, 3.1.1
Statement Cache Purge, 3.1.1
Statement Cache Size, 3.1.1
User Id, 3.1.1
Validate Connection, 3.1.1, 3.1.2.1
ConnectionString property, 3.1.2, 3.1.2.1
Constraints property, 3.10
configuring, 3.10.2
controlling query reexecution, 3.9

D

data loss, 3.8
data manipulation
using XML, 3.7.7
database
changes to, 3.7.7
DataSet, 3.6.3
updating, 3.5.6
updating to database, 3.10
DataTable, 3.10.2
Datatable properties, 3.10
DbType
inference, 3.2.2.3
debug tracing, 3.12
registry settings, 3.12.1
Decr Pool Size attribute
Validate Connection attribute, 3.1.2
default mapping
improving, 3.7.7.6.3
documentation, 2.3
Dynamic Help, Visual Studio .Net
documentation, 2.2

E

error handling
array bind operations
error handling, 3.2.2.5.2
example
connection pooling, 3.1.2
ExecuteNonQuery method, 3.5.5
ExecuteScalar method, 3.5.7

F

FailoverEvent Enumeration, 7
FailoverReturnCode Enumeration, 7
FailoverType Enumeration, 7
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

G

Global Assembly Cache (GAC), 2.2
globalization settings, 3.11.1
client, 3.11.1.1
session, 3.11.1.2
thread-based, 3.11.1.3
globalization support, 3.11
globalization-sensitive operations, 3.11.2
grid-computing, Preface, Preface
grids, Preface, Preface

H

handling date and time format
manipulating data in XML, 3.7.7.1
retrieving queries in XML, 3.7.6.1

I

improving default mapping, 3.7.7.6.3
Incr Pool Size attribute, 3.1.2
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, 3.4.2
InitialLONGFetchSize property, 3.4.2
input binding
XMLType column, 3.7.3.2.1
installation, 2.2
ODP.NET, 2.2
Oracle Data Provider for .NET, 2.2
Integrated Help, 2.2
interference in OracleParameter class, 3.2.2.3
introduction, overview, 1.1
InvalidCastException, 3.4.1.1

L

large binary datatypes, 3.6.1
large character datatypes, 3.6.1
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

Max Pool Size attribute, 3.1.2
metadata, 3.10.3
Microsoft Transaction Server, 2.1
Min Pool Size attribute, 3.1.2
MTS, 2.1
Multiple Oracle Homes, Preface
multiple tables
changes to, 3.7.7.8

N

native XML support, 3.7
NCLOB, 3.6
.NET Framework datatype, 3.3
.NET Stream class, 3.6.2
.NET type accessors, 3.4.1.1
.NET Types
inference, 3.2.2.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, Oracle Call Interface
statement caching, 3.2.3
ODP.NET
installing, 2.2, 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, 10
ODP.NET Type structures, 3.3, 9
ODP.NET Types, 3.3
overview, 3.3
ODP.NET XML Support, 3.7
operating system authentication, 3.1.3
Oracle 8.1.7, 3.7
saving changes to, 3.7.7.6.1
Oracle Data Provider for .NET
installing, 2.2
system requirements, 2.1
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 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
constructors, 8
instance methods, 8
instance properties, 8
members, 8
static fields, 8
static methods, 8
OracleBFile Class, 8
OracleBinary
constructor, 9
instance methods, 9
members, 9
properties, 9
static fields, 9
static methods, 9
static operators, 9
static type conversion operators, 9
OracleBinary Structure, 9
OracleBlob
constructors, 8
instance methods, 8
instance properties, 8
members, 8
static fields, 8
static methods, 8
OracleBlob Class, 8
OracleClob
constructors, 8
instance methods, 8
instance properties, 8
members, 8
static fields, 8
static methods, 8
OracleClob Class, 8
OracleCollectionType Enumeration, 4
OracleCommand
ArrayBindCount, 4
constructors, 4
members, 4
properties, 4
public methods, 4
static methods, 4
OracleCommand ArrayBindCount property, 3.2.2.5
OracleCommand Class, 4
OracleCommand class
FetchSize property, 3.4.4.1
OracleCommand object, 3.2
OracleCommand Transaction object, 3.2.1
OracleCommandBuilder, 3.10.3
constructors, 4
event delegates, 4
events, 4
members, 4
properties, 4
public methods, 4
static methods, 4
updating dataset, 3.10
OracleCommandBuilder Class, 4
OracleConnection
constructors, 4
event delegates, 4
events, 4
members, 4
obtaining a reference, 3.7.2
properties, 4
public methods, 4
static methods, 4
OracleConnection Class, 4
Oracle.DataAccesss.dll assembly, 2.3
OracleDataAdapter, 3.8
constructors, 4
event delegates, 4
events, 4
FillSchema, 3.10.2, 3.10.3
members, 4
properties, 4
public methods, 4
Requery property, 3.9
SafeMapping Property, 3.8.2
SelectCommand, 3.10.1, 3.10.3
static methods, 4
OracleDataAdapter Class, 4
OracleDataAdapter Safe Type Mapping, 3.8
OracleDataReader, 3.4
members, 4
properties, 4
public methods, 4
static methods, 4
OracleDataReader Class, 4
OracleDataReader class
FetchSize property, 3.4.4.1
OracleDataReader SchemaTable, 4
OracleDate
constructors, 9
members, 9
methods, 9
properties, 9
static fields, 9
static methods, 9
static operators, 9
static type conversions, 9
OracleDate Structure, 9
OracleDbType
inference, 3.2.2.3
OracleDbType enumeration type, 3.2.2.2, 4
OracleDbType enumeration values, 3.2.2.3
OracleDecimal
constructors, 9
instance methods, 9
members, 9
properties, 9
static comparison methods, 9
static comparison operators, 9
static logarithmic methods, 9
static manipulation methods, 9
static operators, .NET Type to OracleDecimal, 9
static operators, OracleDecimal to .NET, 9
static trignonmetric methods, 9
OracleDecimal Structure, 9
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, 7
properties, 7
public methods, 7
OracleFailoverEventHandler Delegate, 7
OracleGlobalization
members, 6
properties, 6
public methods, 6
OracleInfoMessageEventArgs
members, 4
properties, 4
public methods, 4
static methods, 4
OracleInfoMessageEventHandler Delegate, 4
OracleIntervalDS
constructors, 9
members, 9
methods, 9
properties, 9
static methods, 9
static operators, 9
type conversions, 9
OracleIntervalDS Structure, 9
OracleIntervalYM
constructors, 9
members, 9
methods, 9, 9
properties, 9
static fields, 9
static operators, 9
type conversions, 9
OracleIntervalYM Structure, 9
OracleNullValueException
constructors, 10
members, 10
methods, 10, 10
properties, 10
OracleNullValueException Class, 10
OracleParameter
ArrayBindSize, 4
ArrayBindStatus, 4
constructors, 4
inferences of types, 3.2.2.3
members, 4
properties, 4
public methods, 4
static methods, 4
OracleParameter array bind feature, 3.2.2.5
OracleParameter array bind properties, 3.2.2.5.1
OracleParameter Class, 4, 4
OracleParameter class
Value, 3.2.2.3.3
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, 4
public methods, 4
static methods, 4
OracleParameterCollection Class, 4
OracleParameterStatus enumeration type, 3.2.2.5.3, 4
OracleRefCursor, 3.5
instance methods, 8
members, 8
populating, 3.5.5
properties, 8
static methods, 8
OracleRefCursor Class, 8
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, 9
members, 9
methods, 9
properties, 9
static fields, 9
static methods, 9
static operators, 9
type conversions, 9
OracleString Structure, 9
OracleTimeStamp
constructors, 9
members, 9
methods, 9
properties, 9
static methods, 9
static operators, 9
static type conversions, 9
OracleTimeStamp Structure, 9
OracleTimeStampLTZ
constructors, 9
members, 9
methods, 9
properties, 9
static fields, 9
static methods, 9
static type conversions, 9
static type operators, 9
OracleTimeStampLTZ Structure, 9
OracleTimeStampTZ
constructors, 9
members, 9
methods, 9
properties, 9
static fields, 9
static methods, 9
static operators, 9
static type conversions, 9
OracleTimeStampTZ Structure, 9
OracleTransaction
members, 4
properties, 4
public methods, 4
static methods, 4
OracleTruncateException
constructors, 10
members, 10
methods, 10
properties, 10
static methods, 10
OracleTruncateException Class, 10
OracleTypeException
constructors, 10
members, 10
properties, 10
static methods, 10
OracleTypeException Class, 10
OracleXmlPropertyCollection Class, 5
OracleXmlStream Class, 5
OracleXmlType, 3.7.2
OracleXmlType Class, 5

P

parameter binding, 3.2.2
password expiration, 3.1.5
performance, 3.2.3
array binding, 3.2.2.5
connection pooling, 3.1.2
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 language, 3.5
PL/SQL REF CURSOR, 3.5
PL/SQL REF CURSOR and OracleRefCursor, 3.5
PLSQLAssociativeArray, 4
Pooling attribute, 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.8, 3.8.2
PrimaryKey property, 3.10
configuring, 3.10.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.9
round-trip, 3.2.2.5
RowSize property, 3.4.4.3

S

Safe Type Mapping, 3.8
SafeMapping Property, 3.8.2
Samples, 1.3, 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, 4
session globalization parameters, 3.11.2.3
session globalization settings, 3.11.1.2
Size property, 3.2.2.4
special characters
in column data, 3.7.7.3
in table or view, 3.7.7.4
special characters in XML, 3.7.5
Statement Caching
connection string attributes, 3.2.3.1
methods and properties, 3.2.3.2
Statement Cache Size, 3.2.3
Statement Change Purge, 3.2.3
Stream class, 3.6.2
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.7.7.4
TAF, 3.1.7
TAF callback support, 3.1.7
Temporary LOBs, 3.6.6
thread globalization settings, 3.11.2.2
thread-based globalization settings, 3.11.1.3
TraceFileName, 3.12.1.1
TraceLevel, 3.12.1.2
TraceOption, 3.12.1.3
Transaction object, 3.2.1
Transparent Application Failover (TAF), 3.1.7
troubleshooting, 3.12
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.10.2
uniqueness
in updating DataSet to database, 3.10
uniqueness in DataRows, 3.10.1
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.10.3
using FetchSize property, 3.4.4.1

V

Value property, 3.2.2.4

X

XML
data manipulation using, 3.7.7
special characters, 3.7.5
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 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