ODAC文檔fordelphi资源-CSDN文库

ODAC

需积分: 9 29 浏览量 2014-12-10 11:11:44 上传评论收藏 9.23MB PDF 举报

资源推荐

资源详情

资源评论

IContents

Table of Contents

Part I Overview

Part II Getting Started

Part III Features

Part IV What's New

Part V Demo Projects

Part VI Component List

Part VII Hierarchy Chart

Part VIII Compatibility

Part IX Editions

Part X Requirements

Part XI Installation

Part XII Deployment

Part XIII Licensing

Part XIV Getting Support

Part XV Frequently Asked Questions

Part XVI Using ODAC

................................................................................................................................... 481 Connecting in Direct Mode

................................................................................................................................... 502 Updating Data with ODAC Dataset Components

................................................................................................................................... 513 Master/Detail Relationships

................................................................................................................................... 524 Automatic Key Field Value Generation

................................................................................................................................... 535 TOraLoader Component

................................................................................................................................... 536 TOraTransaction Component

................................................................................................................................... 557 TOraQueue, TOraQueueAdmin and TOraQueueTable Components

................................................................................................................................... 578 TOraChangeNotification Component

................................................................................................................................... 589 BLOB and CLOB Data Types

................................................................................................................................... 6110 Unicode Character Data

Oracle Data Access ComponentsII

................................................................................................................................... 6211 Objects

................................................................................................................................... 6412 XMLTYPE Data Type

................................................................................................................................... 6613 VARRAY Data Type

................................................................................................................................... 6714 DML Array

................................................................................................................................... 6815 PL/SQL Tables

................................................................................................................................... 6916 Writing Oracle External Procedures with ODAC

................................................................................................................................... 7117 Transparent Application Failover Support

................................................................................................................................... 7318 Working in an Unstable Network

................................................................................................................................... 7419 Disconnected Mode

................................................................................................................................... 7520 Data Type Mapping

................................................................................................................................... 7921 Data Encryption

................................................................................................................................... 8022 Increasing Performance

................................................................................................................................... 8223 Using Connection Pooling

................................................................................................................................... 8324 Macros

................................................................................................................................... 8425 Using Several DAC Products in One IDE

................................................................................................................................... 8526 DataSet Manager

................................................................................................................................... 8927 DBMonitor

................................................................................................................................... 9028 Migration Wizard

................................................................................................................................... 9029 Writing GUI Applications with ODAC

................................................................................................................................... 9030 Compatibility with Previous Versions

................................................................................................................................... 9131 Oracle Package Wizard

................................................................................................................................... 9332 Integration with Developer Tools

.......................................................................................................................................................... 93

dbForge Studio for Oracle

.......................................................................................................................................................... 95

OraDeveloper Tools

.......................................................................................................................................................... 99

OraTools Add-In

................................................................................................................................... 10033 64-bit Development with Embarcadero RAD Studio XE2

................................................................................................................................... 10434 Database Specific Aspects of 64-bit Development

Part XVII Reference

104

................................................................................................................................... 1061 BDESession

.......................................................................................................................................................... 107

Classes

......................................................................................................................................................... 107

TBDESession Class

......................................................................................................................................... 108

Members

......................................................................................................................................... 111

Properties

................................................................................................................................... 115

Database Property

................................................................................................................................... 116

DatabaseName Property

................................................................................................................................... 116

SessionName Property

................................................................................................................................... 1162 CRAccess

.......................................................................................................................................................... 117

Classes

......................................................................................................................................................... 117

TCRCursor Class

......................................................................................................................................... 118

Members

.......................................................................................................................................................... 118

Types

......................................................................................................................................................... 118

TBeforeFetchProc Procedure Reference

.......................................................................................................................................................... 119

Enumerations

IIIContents

III

......................................................................................................................................................... 119

TCRIsolationLevel Enumeration

......................................................................................................................................................... 120

TCRTransactionAction Enumeration

.......................................................................................................................................................... 120

Variables

......................................................................................................................................................... 120

MacroChar Variable

................................................................................................................................... 1203 CRBatchMove

.......................................................................................................................................................... 121

Classes

......................................................................................................................................................... 121

TCRBatchMove Class

......................................................................................................................................... 122

Members

......................................................................................................................................... 123

Properties

................................................................................................................................... 125

AbortOnKeyViol Property

................................................................................................................................... 125

AbortOnProblem Property

................................................................................................................................... 126

ChangedCount Property

................................................................................................................................... 126

CommitCount Property

................................................................................................................................... 126

Destination Property

................................................................................................................................... 127

FieldMappingMode Property

................................................................................................................................... 127

KeyViolCount Property

................................................................................................................................... 127

Mappings Property

................................................................................................................................... 128

Mode Property

................................................................................................................................... 128

MovedCount Property

................................................................................................................................... 129

ProblemCount Property

................................................................................................................................... 129

RecordCount Property

................................................................................................................................... 129

Source Property

......................................................................................................................................... 130

Methods

................................................................................................................................... 130

Execute Method

......................................................................................................................................... 130

Events

................................................................................................................................... 131

OnBatchMoveProgress Event

.......................................................................................................................................................... 131

Types

......................................................................................................................................................... 131

TCRBatchMoveProgressEvent Procedure Reference

.......................................................................................................................................................... 132

Enumerations

......................................................................................................................................................... 132

TCRBatchMode Enumeration

......................................................................................................................................................... 133

TCRFieldMappingMode Enumeration

................................................................................................................................... 1334 CREncryption

.......................................................................................................................................................... 134

Classes

......................................................................................................................................................... 134

TCREncryptor Class

......................................................................................................................................... 134

Members

......................................................................................................................................... 135

Properties

................................................................................................................................... 135

DataHeader Property

................................................................................................................................... 136

EncryptionAlgorithm Property

................................................................................................................................... 136

HashAlgorithm Property

................................................................................................................................... 136

InvalidHashAction Property

................................................................................................................................... 137

Passw ord Property

......................................................................................................................................... 137

Methods

................................................................................................................................... 138

SetKey Method

.......................................................................................................................................................... 138

Enumerations

......................................................................................................................................................... 139

TCREncDataHeader Enumeration

......................................................................................................................................................... 139

TCREncryptionAlgorithm Enumeration

......................................................................................................................................................... 140

TCRHashAlgorithm Enumeration

......................................................................................................................................................... 140

TCRInvalidHashAction Enumeration

................................................................................................................................... 1405 DAAlerter

.......................................................................................................................................................... 141

Classes

......................................................................................................................................................... 141

TDAAlerter Class

......................................................................................................................................... 142

Members

......................................................................................................................................... 142

Properties

Oracle Data Access ComponentsIV

................................................................................................................................... 143

Active Property

................................................................................................................................... 143

AutoRegister Property

................................................................................................................................... 143

Connection Property

......................................................................................................................................... 144

Methods

................................................................................................................................... 144

SendEvent Method

................................................................................................................................... 145

Start Method

................................................................................................................................... 145

Stop Method

......................................................................................................................................... 145

Events

................................................................................................................................... 146

OnError Event

.......................................................................................................................................................... 146

Types

......................................................................................................................................................... 146

TAlerterErrorEvent Procedure Reference

................................................................................................................................... 1476 DADump

.......................................................................................................................................................... 147

Classes

......................................................................................................................................................... 148

TDADump Class

......................................................................................................................................... 148

Members

......................................................................................................................................... 149

Properties

................................................................................................................................... 150

Connection Property

................................................................................................................................... 150

Debug Property

................................................................................................................................... 151

Options Property

................................................................................................................................... 151

SQL Property

................................................................................................................................... 152

TableNames Property

......................................................................................................................................... 152

Methods

................................................................................................................................... 153

Backup Method

................................................................................................................................... 153

BackupQuery Method

................................................................................................................................... 154

BackupToFile Method

................................................................................................................................... 154

BackupToStream Method

................................................................................................................................... 155

Restore Method

................................................................................................................................... 155

RestoreFromFile Method

................................................................................................................................... 156

RestoreFromStream Method

......................................................................................................................................... 156

Events

................................................................................................................................... 157

OnBackupProgress Event

................................................................................................................................... 157

OnError Event

................................................................................................................................... 158

OnRestoreProgress Event

......................................................................................................................................................... 158

TDADumpOptions Class

......................................................................................................................................... 158

Members

......................................................................................................................................... 159

Properties

................................................................................................................................... 159

AddDrop Property

................................................................................................................................... 160

GenerateHeader Property

................................................................................................................................... 160

QuoteNames Property

.......................................................................................................................................................... 160

Types

......................................................................................................................................................... 161

TDABackupProgressEvent Procedure Reference

......................................................................................................................................................... 161

TDARestoreProgressEvent Procedure Reference

................................................................................................................................... 1617 DALoader

.......................................................................................................................................................... 162

Classes

......................................................................................................................................................... 162

TDAColumn Class

......................................................................................................................................... 163

Members

......................................................................................................................................... 163

Properties

................................................................................................................................... 163

FieldType Property

................................................................................................................................... 164

Name Property

......................................................................................................................................................... 164

TDAColumns Class

......................................................................................................................................... 165

Members

......................................................................................................................................... 165

Properties

................................................................................................................................... 165

Items Property(Indexer)

VContents

......................................................................................................................................................... 166

TDALoader Class

......................................................................................................................................... 166

Members

......................................................................................................................................... 167

Properties

................................................................................................................................... 168

Columns Property

................................................................................................................................... 168

Connection Property

................................................................................................................................... 168

TableName Property

......................................................................................................................................... 169

Methods

................................................................................................................................... 169

CreateColumns Method

................................................................................................................................... 170

Load Method

................................................................................................................................... 170

LoadFromDataSet Method

................................................................................................................................... 170

PutColumnData Method

................................................................................................................................... 171

PutColumnData Method

................................................................................................................................... 171

PutColumnData Method

......................................................................................................................................... 172

Events

................................................................................................................................... 172

OnGetColumnData Event

................................................................................................................................... 173

OnProgress Event

................................................................................................................................... 174

OnPutData Event

.......................................................................................................................................................... 174

Types

......................................................................................................................................................... 174

TDAPutDataEvent Procedure Reference

......................................................................................................................................................... 175

TGetColumnDataEvent Procedure Reference

......................................................................................................................................................... 175

TLoaderProgressEvent Procedure Reference

................................................................................................................................... 1768 DAScript

.......................................................................................................................................................... 176

Classes

......................................................................................................................................................... 177

TDAScript Class

......................................................................................................................................... 177

Members

......................................................................................................................................... 179

Properties

................................................................................................................................... 180

Connection Property

................................................................................................................................... 180

DataSet Property

................................................................................................................................... 181

Debug Property

................................................................................................................................... 181

Delimiter Property

................................................................................................................................... 181

EndLine Property

................................................................................................................................... 182

EndOffset Property

................................................................................................................................... 182

EndPos Property

................................................................................................................................... 182

Macros Property

................................................................................................................................... 183

SQL Property

................................................................................................................................... 183

StartLine Property

................................................................................................................................... 183

StartOffset Property

................................................................................................................................... 184

StartPos Property

................................................................................................................................... 184

Statements Property

......................................................................................................................................... 185

Methods

................................................................................................................................... 186

BreakExec Method

................................................................................................................................... 186

ErrorOffset Method

................................................................................................................................... 186

Execute Method

................................................................................................................................... 187

ExecuteFile Method

................................................................................................................................... 187

ExecuteNext Method

................................................................................................................................... 188

ExecuteStream Method

................................................................................................................................... 188

FindMacro Method

................................................................................................................................... 189

MacroByName Method

......................................................................................................................................... 189

Events

................................................................................................................................... 190

AfterExecute Event

................................................................................................................................... 190

BeforeExecute Event

................................................................................................................................... 190

OnError Event

......................................................................................................................................................... 191

TDAStatement Class