Skip Headers
Oracle® Data Provider for .NET Developer's Guide
10g Release 2 (10.2)
Part Number B14307-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
Contact Us
Go to previous page
Previous
PDF · Mobi · ePub

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
Go to previous page
Previous
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
Contact Us