Index

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

A

Abs method, 10

Access Violations, 5.3.3

accessing

collection elements, 4.5.3

OraObject, 4.4.4.2

OraObject attributes, 4.4.2.2

referenceable instance, 4.4.4.2

accessing the OO4O Automation Server, 3.2

Active Server Pages, 1.1, 2.1, 2.4

Active Server Pages with OO4O Automation, 2.4

ActiveX Control, 1.3, 2.8

AddTable method, 3.8.4

advanced features of Oracle Objects for OLE, 4

advanced queuing interfaces, 4.6

AllowMoveLast property, 14

application failover notifications, 4.8

application notifications, 4.8.1

array processing, 5.1.5

ASP, 1.1, 2.4

asynchronous dequeuing, 4.6.1

AutoBindDisable method, 5.1.4

AutoBindEnable method, 5.1.4

automation objects

introduction, 8

Automation Server, 3.2

avoiding multiple object reference, 5.1.3

B

BackColor property, 14

batch inserts, 6

BeginTrans method, 3.9

bind variables, 3.8

bindings, 5.1.4

Borland Delphi, 1.5.2

bound class, 1.4

buffering

LOB, 4.3.4

bulk collect feature, 5.1.7

C

C++, 1.4

cache parameters, 5.1.2

caching, 3.4.1

Caption property, 14

chunking methods

LONG RAW, 5.1.8

client applications, 3

code examples

location, 2.2

Code Wizard

using, 7.3

Code Wizard Components, 7.1

Code Wizard data types, 7.2

Code Wizard examples, 7.4

Code Wizard for stored procedures, 7

collection elements

accessing, 4.5.3

modifying, 4.5.4

collection types

retrieving from the database, 4.5.2

VARRAY, 4.5.5

collections, 4.5

OraFields, 5.1.3

COM Automation Objects, 1.2

commands

executing, 3.4

CommitTrans method, 3.9

Complex Object Retrieval Capability (COR) in OCI, 4.4.3

Component Certifications

OracleMetaLinkOracleMetaLink, 1.7

configuration information, 1.8.2

Connect data control property, 14

connection information

incorrectly specified, 5.3.2

connection multiplexing, 3.3.1

connection pool, 5.1.9

connection pool management, 3.6

connection pooling, 2.4, 5.1.9

connpool sample (IIS), 2.4

constant file, 2.2.1.3

CreateCustomDynaset method, 5.1.2

CreateSQL method, 3.4.2.1, 3.8, 5.1.5

creating

dynaset from OraCollection, 4.5.6

VARRAY collection type, 4.5.5

customization, 5.1.2

D

data control recordset, 13

data controls, 2.1

Data Definition Language (DDL) statements, 3.8.5

Data Manipulation Language (DML) Statements, 3.4.2

data streaming, 4.3.4

data types, 4.4

datetime, 4.10

interval, 4.10

data types supported by the OO4O Code Wizard, 7.2

database connectivity APIs, 1.2

Database data control property, 14

database events, 4.7

detection, 4.7

database records

updating, 3.4.2.1

database schema objects, 4.11

DatabaseName data control property, 14

datetime data types, 4.10

DBGrid Control, 2.8

DDL statements, 3.8.5

deleting rows from table, 3.4.2.2

demodrp7.sql, 2.2.1

demonstration

Excel, 2.5

Oracle Data Control, 2.7

Oracle Data Control with VC++, 2.8

quick tour, 6

demonstration schema, 2.2

creation, 2.2.1

demonstration tables

dept, 2.2.1

emp, 2.2.1

dept table, 2.2.1

dequeuing, 4.6.1

detection of database events, 4.7

differences LOB types from LONG RAW, 5.1.8

DirtyWrite property, 14

disabling parameter binding, 5.1.4

DML statements, 3.4.2

Drag method, 12, 13

DragDrop event, 12

DragIcon property, 14

DragMode property, 14

DragOver event, 12

Drop method, 12

Dyanset object

using, 4.4.4.1.1

dynaset

creating from an OraCollection, 4.5.6

Dynaset object

using, 4.4.2.1.1

dynasets

using, 5.1.6

E

early binding of OO4O Objects, 5.1.1

Edit method, 13

EditMode property, 14

emp table, 2.2.1

empcur.sql, 2.2.1.3

Enabled property, 14

enabling failover, 4.8.2

enabling parameter bindinng, 5.1.4

error code

ODCERR_AUTOMATION, 5.2.11

Error data control event, 12

error handling, 5.2

errors

Access Viloations, 5.3.3

Advanced Queuing, 5.2.7

Collection, 5.2.8

Find method parser, 5.2.3

incorrectly installed software, 5.3.1

installation, 5.3.3

network errors, 5.3.2

nonblocking, 5.2.2

OLE Automation, 5.2.1

OLE Initialization or OLE Automation, 5.3.1

Oracle, 5.2.10

Oracle Data Control, 5.2.11

Oracle LOB, 5.2.6

Oracle Number, 5.2.9

Oracle object instance, 5.2.5

troubleshooting, 5.3

events

database, 4.7

ExampleDb, 2.2.1

examples, 2.1, 2.2.1.3

Code Wizard, 7.4

Excel demo, 2.5

Excel with OO4O automation, 2.5

ExecuteSQL method, 3.4.2.1, 3.8, 5.1.5

executing commands, 3.4

executing Data Definition Language (DDL) statements, 3.8.5

executing methods

OraObject, 4.4.2.4

executing PL/SQL blocks, 3.8

F

failover, 4.8

enabling, 4.8.2

notification, 4.8.2

Failover Notification Registration, 4.8.1

features

advanced, 4

new, Preface

fetch parameters, 5.1.2

FetchLimit property, 5.1.2

file locations, 1.5

Find method, 5.2.2

parser errors, 5.2.3

run-time errors, 5.2.3

Font property, 14

ForeColor property, 14

G

global.asa file, 2.4

grid control, 1.3

H

Height property, 14

I

IIS, 2.1

IIS Active Server Pages, 1.1

IIS Microsot Internet Information Server, 2.4

incorrectly installed software

errors, 5.3.1

incorrectly specified connection information, 5.3.2

Index data control property, 14

InProcServer Type Library, 2.3

input variables, 4.1

inserting multiple rows, 3.4.2.3

inserting new rows in table, 3.4.2.3

installation, 1.5

installation errors, 5.3.3

instance errors, 5.2.5

interfaces

OO4O, 4.3.1

retrieving, 4.2.1

interval data types, 4.10

J

Java stored procedures, 7

L

large objects, 5.1.8

Large Objects (LOBs)

using, 4.3

LastServerErr property, 5.2.1, 5.2.10

LastServerErrText property, 5.2.10

Left property, 14

LOB buffering, 4.3.4

LOB data

multiple-piece read operation, 4.3.6

reading, 4.3.6

writing, 4.3.5

LOB data single-piece read operation, 4.3.6

LOB datatatypes

support for, 4.1

LOBs, 5.1.8

data types, 4.3.1

retrieving from database, 4.3.3

using, 4.3

Long, 5.1.8

LONG RAW

chunking methods, 5.1.8

migration from, 5.1.8

types, 5.1.8

Long types, 5.1.8

M

messages

enqueuing, 4.6

monitoring, 4.6.1

methods

AutoBindDisable, 5.1.4

AutoBindEnable, 5.1.4

CreateCustomDynaset, 5.1.2

CreateSQL, 5.1.5

ExecuteSQL, 5.1.5

Find, 5.2.2, 5.2.3

Server, 10

MFC AppWizard, 2.8

Microsoft Access, 1.5.2

Microsoft data control, 1.3

Microsoft Foundation Classes, 1.4

Microsoft Information Server, 2.1

Microsoft Internet Information Server (IIS), 1.5.2

Microsoft Internet Service Manager, 2.4

Microsoft Transaction Server support, 3.10

Microsoft VC++, 1.8, 2.8

Microsoft Visual Basic

Microsoft Excel, 1.5.2

migration from LONG RAW to LOB or BFILE, 5.1.8

modfiying attributes

OraObject, 4.4.4.3

referenceable instance, 4.4.4.3

modifying

collection elements, 4.5.4

OraObject attributes, 4.4.2.3

MonitorForFailover method, 4.8.1

monitoring

messages, 4.6.1

MonitorStart method, 4.6.1

MonitorStop method, 4.6.1

MouseDown event, 12

MouseMove event, 12

MousePointer property, 14

MouseUp event, 12

Move data control method, 13

MTS support, 3.10

multicur.sql, 2.2.1.3

multiple Oracle homes, system requirements, 1.5

multiple rows, 3.4.2.3

multiple-piece operation, 4.3.4

multiple-piece read operation, 4.3.6

multiple-piece write operation, 4.3.5

multiplexing, 3.3.1

N

Name data control property, 14

nested tables, 4.1, 4.5

network alias

ExampleDb, 2.2.1

network service alias, 2.2.1

network trips, 5.1.7

reducing, 5.1.5, 5.1.6

Nonblocking Errors, 5.2.2

nonblocking mode, 4.6.1

NoRefetch property, 14

notifications

application failover, 4.8, 4.8.1

O

object data types, 4.4

Object-relational features

support for, 4.1

Objects, 9

objects

OraBLOB, OraCLOB, 5.2.6

OraCollection, 5.1.7

OraCollection errors, 5.2.8

OraDynaset, 5.1.3, 5.1.7

OraField, 5.1.3

OraObject, 5.2.5

OraParamArray, 5.1.5, 5.1.7

OraParameter, 5.1.4

ODBC, 1.2

ODCERR_AUTOMATION error code, 5.2.11

oip10.dll, 1.8.2

oiplang.msb, 1.8.2

OLE Automation Errors, 5.2.1

OLE Initialization or OLE Automation Errors, 5.3.1

OO4O Automation Server, 3.2

OO4O Code Wizard

requirements, 1.5.3

using, 7.3

OO4O Code Wizard Components, 7.1

OO4O Code Wizard examples, 7.4

OO4O Code Wizard Visual Basic Wizard, 7.3.2

OO4O File Locations, 1.6

OO4O In-Process Automation Server, 1.2, 5.2.1

OO4O methods, 10

OO4O Objects, 9

OO4O Redistributable Files, 1.8

OO4O server methods, 10

OO4O server properties, 11

OO4OCodeWiz.exe, 7.3

oo4oparm.reg file, 1.8.2

oorodemo.asp file, 2.4

option flags, 2.2.1.3

options

ORADYN_NOCACHE, 5.1.6

ORADYN_READONLY, 5.1.6

Options data control property, 14

OraAQ interface, 4.6

OraAQ object, 4.6.1

OraAQMsg object, 4.6

OraAttributes interface, 4.4.1

OraBLOB and OraCLOB

objects, 5.2.6

using, 4.3.2

Oracle Advanced Queuing Errors, 5.2.7

Oracle Call Interface (OCI), 4.4.3

Oracle Collection Errors, 5.2.8

Oracle Collections, 4.5

Oracle Data Control, 1.3, 1.8.2, 2.2.1, 2.8

requirements, 1.5.3

setting properties, 2.7.2

Oracle Data Control demonstration, 2.7

Oracle Data Control errors, 5.2.11

Oracle Data Control events, 12

DragDrop, 12

DragOver, 12

Error, 12

MouseDown, 12

MouseMove, 12

MouseUp, 12

Reposition, 12

Validate, 12

Oracle Data Control methods, 13

Drag, 13

Move, 13

Refresh, 13

UpdateControls, 13

UpdateRecord, 13

ZOrder, 13

Oracle Data Control properties, 14

AllowMoveLast, 14

AutoBind lAutoBind property, 14

BackColor, 14

Caption, 14

Connect, 14

Database, 14

DatabaseName, 14

DirtyWrite, 14

DragIcon, 14

DragMode, 14

EditMode, 14

Enabled, 14

Font, 14

ForeColor, 14

Height, 14

Index, 14

Left, 14

MousePointer, 14

Name, 14

NoRefetch, 14

Options, 14

OracleMode, 14

ReadOnly, 14

Recordset, 14

RecordSource, 14

Session, 14

Tag, 14

Top, 14

TrailingBlanks, 14

Visible, 14

Width, 14

Oracle Data Control with Visual Basic, 2.7

Oracle Errors, 5.2.10

Oracle In-Process Server Type library, 1.5.3

Oracle LOB errors, 5.2.6

Oracle LOBs, Objects, and Collections, 4.2.1

instantiating, 4.2

Oracle network errors, 5.3.2

Oracle Number errors, 5.2.9

Oracle Object Instance Errors, 5.2.5

Oracle Objects for OLE (OO4O) overview, 1.1

Oracle Objects for OLE C++ Class Library, 1.4

Oracle Objects for OLE server methods, 10

Oracle Objects for OLE Server Objects, 9

Oracle Objects for OLE server properties, 11

Oracle Universal Installer, 1.5.2, 1.8

OracleMode property, 14

oraclm32.dll, 1.8

OraCollection, 4.5

OraCollection interface, 4.5.1

OraCollection object, 5.1.7, 5.2.8

creating a dynaset from, 4.5.6

oraconst.txt, 2.2.1.3

OraDatabase object

pool of, 5.1.9

pool, performance, ASP applications, 3.6

OraDatabase objects, 13

ORADC Control, 2.8

oradc.ocx, 1.8, 1.8.2

ORADYN_NOCACHE option, 3.4.1, 5.1.6

ORADYN_READONLY option, 5.1.6

OraDynaset

objects, 13

XML from, 4.9

OraDynaset object, 5.1.3, 5.1.7

using, 4.3.3

oraexamp.sql, 2.2.1.3

OraField objects, 5.1.3

OraFields collection, 5.1.3

OraMetaData object, 4.11

OraObject interface, 4.4.1

using, 4.4.2

OraObject object, 4.4

accessing, 4.4.4.2

accessing attributes of, 4.4.2.2

executing methods, 4.4.2.4

instance errors, 5.2.5

modfiying attributes, 4.4.4.3

modifying attributes of, 4.4.2.3

retrieving, 4.4.2

OraParamArray object, 5.1.5, 5.1.7

OraParameter object, 5.1.4

using, 4.4.4.1.2

OraRef interface

about, 4.4.3

using, 4.4.4

OraRef object, 4.4

OraSQLStmt, 3.4.2.1

ORATYPE_CURSOR, 3.8.3

output variables, 4.1

P

parameter bindings, 5.1.4

Parameter object

using, 4.3.3, 4.4.2.1.2

ParameterArrays, 3.4.2.3

performance, 3.4.1, 3.4.2.1, 3.8, 5.1.2

considerations with LOB, 4.3.4

improvement, 5.1.6

PL/SQL bind variables, 3.8

PL/SQL blocks

executing, 3.8

PL/SQL bulk collect feature, 5.1.7

PL/SQL cursor variables, 3.8.3, 3.8.3

PL/SQL procedures, 5.1.4, 7

PL/SQL support, 3.8

PL/SQL tables

returning, 3.8.4

processing

arrays, 5.1.5

properties, 11

FetchLimit, 5.1.2

LastServerErr, 5.2.1, 5.2.10

LastServerErrText, 5.2.10

property values, 2.2.1.3

Q

queries, 3.4.1

queueing, 4.6

quick tour, 6

R

ReadOnly property, 14

Recordset data control property, 14

RecordSource data control property, 13, 14

reducing round-trips, 5.1.5

REF

retrieving from database, 4.4.4.1

referenceable instance, 4.4.4.2, 4.4.4.3

Refresh data control method, 13

Refresh method, 3.8

Reposition event, 12

required setups, 1.5

required support files (RSF), 1.5.2

requirements

OO4O Code Wizard, 1.5.3

Oracle Data Control, 1.5.3

retreiving

interfaces, 4.2.1

retrieving

collection types, 4.5.2

LOBs from database, 4.3.3

OraObject, 4.4.2

REF, 4.4.4.1

returning PL/SQL tables, 3.8.4

round-trips, 4.3.4, 5.1.7

reducing, 5.1.5, 5.1.6

run-time errors, 5.2.3

S

sample application

quick tour, 6

schema objects, 4.11

scott schema, 2.2.1

scott/tiger, 2.2

SELECT statements, 3.4.1

server methods, 10

server properties, 11

Session data control property, 14

Setting Oracle Data Control Properties Programmatically, 2.7.2

setup

required, 1.5

single-piece operation, 4.3.4

single-piece read operation, 4.3.6

single-piece write operation, 4.3.5

sqldembld7.sql, 2.2.1

support for Microsoft Transaction Server, 3.10

support for PL/SQL, 3.8

system requirements, 1.5.2

T

Tag property, 14

tnsnames.ora file, 2.2.1

Top property, 14

TrailingBlanks property, 14

transaction control, 3.9

troubleshooting, 5.3

tuning, 5.1.2

Type Library, 2.3

types, 5.1.8

LONG RAW, 5.1.8

U

Universal Installer, 1.5.2, 1.8

update database records, 3.4.2.1

Update method, 13

UpdateControls method, 13

UpdateRecord method, 13

Updating files and registrations, 1.8.2

using

Dynaset object, 4.4.4.1.1

OraParameter object, 4.4.4.1.2

OraRef interface, 4.4.4

using a Dynaset object, 4.4.2.1.1

using a Parameter object, 4.4.2.1.2

using Automation Clients, 2.1

using Microsoft C++, 2.6

using OO4O Automation with Active Server Pages (ASP), 2.4

using OO4O Automation with Excel, 2.5

using OO4O Automation with Visual Basic, 2.3

using OraBLOB and OraCLOB, 4.3.2

using OraObject interface, 4.4.2

using read-only forward-only dynasets, 5.1.6

using the OO4O Code Wizard, 7.3

using the Oracle Data Control with MS VC++, 2.8

using the Oracle Data Control with Visual Basic, 2.7

using the PL/SQL bulk collect feature, 5.1.7

V

Validate event, 12, 12, 13

VARRAY collection type

creating, 4.5.5

VARRAYs, 4.1, 4.5

Visible property, 14

Visual Basic, 1.1, 5.1.1, 12, 13, 14

Visual Basic for Applications, 1.1

Visual Basic with OO4O automation, 2.3

Visual Basic Wizard Add-in to Code Wizard, 7.3.2

Visual Basic, Excel, 2.1

Visual C++, 1.4, 2.6, 2.8

Visual C++, JavaScript, 1.1

W

Width property, 14

Windows 2000, 1.5.2

Windows NT, 1.5.2

Windows registry parameters, 5.1.2

Windows Server 2003, 1.5.2

Windows XP, 1.5.2

writing

LOB data, 4.3.5

X

XML

generation, 4.9

XML from OraDynaset, 4.9

XML support for, 4.9

XSLT, 4.9

Z

z-order, 13

ZOrder methods, 13