Oracle Heterogeneous Services -- Index

agents

generic connectivity, 1-4

Heterogeneous Services, 1-3

disabling self-registration, 2-6

registering, 2-5, 2-6, 2-7

specifying initialization parameters for, 2-4

application development

Heterogeneous Services, 4-1, 4-2

controlling array fetches between non-Oracle server and agent, 4-11

controlling array fetches between Oracle server and agent, 4-11

controlling reblocking of array fetches, 4-11

DBMS_HS_PASSTHROUGH package, 4-2

pass-through SQL, 4-2

using bulk fetches, 4-9

using OCI for bulk fetches, 4-10

using Heterogeneous Services, 4-1

Architecture of the Heterogenous Services Data Dictionary, 1-6

array fetches, 4-10

agents, 4-11

bind queries

executing using pass-through SQL, 4-7

BIND_INOUT_VARIABLE procedure, 4-3, 4-7

BIND_OUT_VARIABLE procedure, 4-3, 4-6

BIND_VARIABLE procedure, 4-3

buffers

multiple rows, 4-8

bulk fetches

optimizing data transfers using, 4-9

CATHO.SQL script

installing data dictionary for Heterogeneous Services, 2-2

character sets

Heterogeneous Services, A-7

CLOSE_CURSOR function, 4-3

commit point site

commit point strength, A-3

configuring generic connectivity, 3-8

configuring transparent gateways, 2-2

CREATE_INST_INIT procedure, 2-19

data dictionary

contents with generic connectivity, D-3

installing for Heterogeneous Services, 2-2

mapping for generic connectivity, D-4

Oracle server name/SQL Server name, D-4

tables, 1-5

translation support for generic connectivity, D-2

data dictionary views

generic connectivity, D-3

Heterogeneous Services, 2-9, B-1

database links

heterogeneous systems, 1-5, 2-4

datatypes

mapping, 1-5

ODBC, E-2

ODBC to Oracle, E-2

OLE DB, E-3

OLE DB to Oracle, E-3

date formats

Heterogeneous Services, A-8

DBMS_HS package

specifying HS parameters, 2-18

DBMS_HS_PASSTHROUGH package, 4-2

list of functions and procedures, 4-3

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, C-15

describe cache high water mark

definition, A-4

drivers

ODBC, 3-13

OLEFS, 3-16

OLESQL, 3-15

dynamic performance views

Heterogeneous Services, 2-16

determining open sessions, 2-17

determining which agents are on host, 2-16

EXECUTE_IMMEDIATE procedure, 4-3

restrictions, 4-4

EXECUTE_NON_QUERY procedure, 4-3

FDS_CLASS, 2-8

FDS_CLASS_VERSION, 2-8

FDS_INST_NAME, 2-8

FETCH_ROW procedure, 4-3

executing queries using pass-through SQL, 4-7

fetches

bulk, 4-9

optimizing round-trips, 4-8

generic connectivity

architecture, 3-3

Oracle and non-Oracle on same machine, 3-4

Oracle and non-Oracle on separate machines, 3-3

configuration, 3-8

creating initialization file, 3-8

data dictionary

translation support, D-2

definition, 3-2

DELETE statement, 3-7

editing initialization file, 3-9

error tracing, A-6

Heterogeneous Services, 1-4

INSERT statement, 3-7

non-Oracle data dictionary access, D-2

ODBC connectivity requirements, 3-13

OLE DB (FS) connectivity requirements, 3-16

OLE DB (SQL) connectivity requirements, 3-15

restrictions, 3-6

setting parameters for ODBC source, 3-10

UNIX, 3-11

Windows NT, 3-10

setting parameters for OLE DB source, 3-12

SQL execution, 3-6

supported functions, 3-7

supported SQL syntax, 3-7

types of agents, 3-2

UPDATE statement, 3-7

GET_VALUE procedure, 4-3, 4-6, 4-7

heterogeneous distributed systems

accessing, 2-2

Heterogeneous Services

agent registration, 2-5

avoiding configuration mismatches, 2-6

disabling, 2-6

enabling, 2-5

agents

self-registration, 2-7

application development, 4-1, 4-2

controlling array fetches between non-Oracle server and agent, 4-11

controlling array fetches between Oracle server and agent, 4-11

controlling reblocking of array fetches, 4-11

DBMS_HS_PASSTHOUGH package, 4-2

locking behavior of non-Oracle systems, 4-12

pass-through SQL, 4-2

using bulk fetches, 4-9

using OCI for bulk fetches, 4-10

creating database links, 2-4

data dictionary, 1-6

classes and instances, 1-7

data dictionary views, 2-9, B-1

types, 2-10

understanding sources, 2-12

using general views, 2-12

using SQL service views, 2-14

using transaction service views, 2-13

database links to non-Oracle systems, 1-5

DBMS_HS package

using to specify initialization parameters, 2-19

using to unspecify initialization parameters, 2-20

defining maximum number of open cursors, A-9

dynamic performance views, 2-16

V$HS_AGENT view, 2-16

V$HS_SESSION view, 2-17

generic connectivity

architecture, 3-3

creating initialization file, 3-8

definition, 3-2

editing initialization file, 3-9

non-Oracle data dictionary access, D-2

ODBC connectivity requirements, 3-13

OLE DB (FS) connectivity requirements, 3-16

OLE DB (SQL) connectivity requirements, 3-15

restrictions, 3-6

setting parameters for ODBC source, 3-10

setting parameters for OLE DB source, 3-12

SQL execution, 3-6

supported functions, 3-7

supported SQL syntax, 3-7

supported tables, D-3

types of agents, 3-2

initialization parameters

specifying, 2-19

unspecifying, 2-20

installing data dictionary, 2-2

locking behavior of non-Oracle systems, 4-12

optimizing data transfer, A-10

overview, 1-2

setting global name, A-4

setting up access using transparent gateway, 2-2

setting up environment, 2-2

specifying cache high water mark, A-4

specifying cache size, A-10

specifying commit point strength, A-3

specifying domain, A-3

specifying instance identifier, A-4

SQL service, 1-5

testing connections, 2-4

transaction service, 1-4

tuning internal data buffering, A-11

types, 1-4

HS_AUTOREGISTER initialization parameter, 2-18

using to enable agent self-registration, 2-9

HS_BASE_CAPS view, 2-11

HS_BASE_DD view, 2-11

HS_CLASS_CAPS view, 2-11

HS_CLASS_DD view, 2-11

HS_CLASS_INIT view, 2-11

HS_COMMIT_POINT_STRENGTH initialization parameter, A-3

HS_DB_DOMAIN initialization parameter, 2-20, A-3

HS_DB_INTERNAL_NAME initialization parameter, A-4

HS_DB_NAME initialization parameter, A-4

HS_DESCRIBE_CACHE_HWM initialization parameter, A-4

HS_FDS_CLASS view, 2-11

HS_FDS_CONNECT_INFO initialization parameter, A-5

specifying connection information, 3-9

HS_FDS_FETCH_ROWS initialization parameter, 4-11

HS_FDS_INST view, 2-11

HS_FDS_SHAREABLE_NAME initialization parameter, A-6

HS_FDS_TRACE initialization parameter, A-6

HS_FDS_TRACE_FILE_NAME initialization parameter, A-6

HS_FDS_TRACE_LEVEL initialization parameter

enabling agent tracing, 3-10

HS_INST_CAPS view, 2-11

HS_INST_DD view, 2-11

HS_INST_INIT view, 2-11

HS_LANGUAGE initialization parameter, A-7

HS_NLS_DATE_FORMAT initialization parameter, A-8

HS_NLS_DATE_LANGUAGE initialization parameter, A-8

HS_NLS_NCHAR initialization parameter, A-9

HS_OPEN_CURSORS initialization parameter, A-9

HS_ROWID_CACHE_SIZE initialization parameter, A-10

HS_RPC_FETCH_REBLOCKING initialization parameter, 4-11, A-10

HS_RPC_FETCH_SIZE initialization parameter, 4-11, A-11

Limitations to Heterogeneous Services, 4-12

listeners, 2-2

locks

in non-Oracle systems, 4-12

multiple rows

buffering, 4-8

National Language Support (NLS)

Heterogeneous Services, A-7

character set of non-Oracle source, A-9

date format, A-8

languages in character date values, A-8

Net8 listener, 1-3, 2-2

OCI

optimizing data transfers using, 4-10

ODBC agents

connectivity requirements, 3-13

functions, 3-14

ODBC connectivity

data dictionary mapping, D-4

mapping OBDC datatypes, E-2

mapping Oracle datatypes, E-2

ODBC driver, 3-13

requirements, 3-13

specifying connection information

UNIX, A-5

Windows NT, A-5

specifying path to library, A-6

OLE DB agents

connectivity requirements, 3-15, 3-16

OLE DB connectivity

data dictionary mapping, D-4

mapping to Oracle datatypes, E-3

setting connection information, A-5

OLEFS drivers, 3-16

data provider requirements, 3-16

initialization properties, 3-18

rowset properties, 3-18

OLESQL drivers, 3-15

security, 3-15

OPEN_CURSOR procedure, 4-3

operating system dependencies, C-1

Oracle precompiler

optimizing data transfers using, 4-10

OUT bind variables, 4-6

PARSE procedure, 4-3

pass-through SQL, 4-2

avoiding SQL interpretation, 4-2

executing statements, 4-3

non-queries, 4-4

queries, 4-7

with bind variables, 4-4

with IN bind variables, 4-5

with IN OUT bind variables, 4-6

with OUT bind variables, 4-6

implications of using, 4-3

overview, 4-2

restrictions, 4-3

PL/SQL

development environment, 4-2

queries

pass-through SQL, 4-7

reblocking, 4-11

Researching, 4-12

rows

buffering multiple, 4-8

security

OLESQL driver, 3-15

SELECT statement

accessing non-Oracle system, D-2

service names

specifying in database links, 2-4

SQL capabilities

data dictionary tables, 2-15

SQL dialect

understood by non-Oracle system, 1-5

SQL service

capabilities, 1-5

data dictionary views, 1-8, 2-10

Heterogeneous Services, 1-5

views

Heterogeneous Services, 2-14

SQL statements

mapping to non-Oracle datastores, 4-2

transaction service

Heterogeneous Services, 1-4

views

Heterogeneous Services, 2-13

transparent gateways

accessing Heterogeneous Services agents, 2-2

creating database links, 2-4

Heterogeneous Services, 1-3

installing Heterogeneous Services data dictionary, 2-2

testing connections, 2-4

unsupported functions

generic connectivity, 3-7

V$HS_AGENT view

determining which agents are on host, 2-16

V$HS_PARAMETER view

listing HS parameters, 2-18

V$HS_SESSION view

determining open sessions, 2-17

variables

BIND, 4-4