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
oiplang.msb, 1.8.2
oipVER.dll, 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 Client, 1.5.2
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 registry parameters, 5.1.2
Windows Server 2003, 1.5.2
Windows Vista, 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