Index

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

A

access control. See system-level access control, 5.2.3, 7.3

ADD_SUBSCRIBER procedure, 24.6

adding a subscriber, 8.5.1

administration

Messaging Gateway, 18.3.1

administration user

creating, 19.2.5

administrative interface, 5.2.3

AdtMessage, 11.2.9

Advanced Queuing

operations over the Internet, 17.1

agent

identifying, 3.3, 3.4, 3.5

agent. See AQ agent, 8.7.2

agent user

creating, 19.2.6

altering

destination, 12.10.3

AnyData datatype

message propagation, 23.3

queues, 23.2, 23.4

dequeuing, 23.5

enqueuing, 23.5

propagating to typed queues, 23.3

user-defined types, 23.3.1

wrapper for messages, 23.2.1, 23.5

apply process

message handlers

creating, 24.5

AQ agent

altering, 8.7.2

creating, 8.7.1

dropping, 8.7.3

registering, 17.5.4.1

AQ XML

schema, 17.4

servlet, 17.5, 17.5.5

AQ XML servlet

registering for notifications, 7.16.1

AQ_TM_PROCESSES, 3.14.1

AQXmlPublish method, 17.3.1

AQXmlReceive method, 17.3.2

AQXmlSend method, 17.3.1

array

dequeue message array, 10.5

enqueue message array, 10.2

asynchronous notification, 1.11.1, 7.16

asynchronously receiving message, 11.6.5

B

batch dequeue, 10.5

batch enqueue, 10.2

bytes message, 11.2.5

C

commit response, 17.3.9

commit transaction, 17.3.4

compositing, 1.7

configuring

connection information, 19.2.7

connection factory

queue/topic, LDAP, 12.4.5

topic, with JDBC URL, 12.4.3

unregistering in LDAP through database, 12.3.1

unregistering in LDAP through LDAP, 12.3.2

connection information

configuring, 19.2.7

CONVERT_ANYDATA_TO_LCR_DDL function, 23.6

CONVERT_ANYDATA_TO_LCR_ROW function, 23.6

correlation identifier, 1.11.1, 1.11.1

creating

administration user, 19.2.5

agent user, 19.2.6

point-to-point queue, 12.8.1

queue, 8.2.1

queue table, 12.6

queue tables and queues, examples, 2.2.1

creating publish/subscribe topic, 12.8.2

creation of prioritized message queue table and queue, 2.2.1

creation of queue table and queue of object type, 2.2.1

creation of queue table and queue of RAW type, 2.2.1

D

database

tuning, 6.2

database access

enabling, 8.7.4

database objects

loading, 19.2.1

database session, 17.5.4.3

DBA_ATTRIBUTE_TRANSFORMATIONS, 9.17

DBA_QUEUE_TABLES, 9.1, 9.1

DBA_QUEUES, 9.3, 9.3

DBA_TRANSFORMATIONS, 9.16

DBMS_AQADM package, 5.2.1, 5.2.1

DBMS_MGWADM package, 18.3.1

DBMS_TRANSFORM

applying a transformation, 7.5.1

create_transformation, 7.5.1

creating a single PL/SQL function, 7.5.1

DBMS_TRANSFORM package, 23.6, 23.6

delay, 3.13

time specification, 11.5.2

delay interval

retry with, 7.14.7

time specification, 7.13.3

dequeue

client request for, 17.3.2

message array, 10.5

dequeue mode, 3.13

dequeue of messages after preview, 2.2.2

DEQUEUE procedure, 23.5

example, 24.6

dequeue request

server response, 17.3.7

dequeuing, 10.4

features, 7.14

message navigation, 7.14.4

methods, 7.14.1

modes, 1.11.2, 7.14.5, 7.14.5

multiple-consumer dequeuing of one message, 1.4

navigation of messages, 1.11.2

same message, multiple-consumer, 1.4

using HTTP, 7.17

destination

altering, 12.10.3

dropping, 12.10.4

starting, 12.10.1

stopping, 12.10.2

destination-level access control, 11.1.5

disabling

propagation schedule, 8.6.6

dropping

destination, 12.10.4

queue table, 8.1.3

dropping AQ objects, 2.2.4

durable subscriber, 11.4.2

E

enqueue

client request for, 17.3.1

message array, 10.2

server response, 17.3.6

enqueue and dequeue of messages

by Correlation and Message Id Using Pro*C/C++, 2.2.2

by priority, 2.2.2, 2.2.2, 2.2.2

examples, 2.2.2

of object type, 2.2.2

of RAW type, 2.2.2, 2.2.2, 2.2.2

of RAW type using Pro*C/C++, 2.2.2, 2.2.2

to/from multiconsumer queues, 2.2.2, 2.2.2

ENQUEUE procedure, 23.5, 24.4

enqueuing, 10.1, 10.1.3

features, 7.13

specify message properties, 10.1.2

specify options, 10.1.1

enqueuing, priority and ordering of messages, 1.11.1

Enterprise Manager, 1.11.4

enumerated constants

administrative interface, 3.12

operational interface, 3.13

evaluation contexts

creating, 24.5

events

captured

propagating, 23.6

dequeue

programmatic environments, 23.2.2

enqueue

programmatic environments, 23.2.2

user-enqueued

propagating, 23.6

exception handling, 1.11.2, 7.15, 11.6.6

Exception Handling During Propagation, 11.8.3

exception handling during propagation, 11.7.4, 11.8.1

expiration, 3.13

time specification, 7.13.4

exporting

incremental, 5.3.1

queue table data, 5.3.1

F

fanning-out of messages, 1.7

frequently asked questions

Internet access questions, 17.9.1

Oracle Internet Directory, 17.9.2

transformation questions, 2.3.3

funneling-in of messages. See compositing, 1.7

G

gateway agent

managing, 20.1

getting

queue table, 12.7

global agents, 17.9.2

global events, 17.9.2

global queues, 17.9.2

granting

system privilege, 8.4.1

system privileges, 12.9.1

grouping

message, 11.5.4

H

HTTP, 1.9.2, 17.1, 17.2.2.2, 17.5.3.1, 17.5.4.1, 17.6

accessing AQ XML servlet, 17.6

AQ operations over, 17.1

headers, 17.2.2.1

propagation, 17.7

response, 17.2.2.3

HTTPS

propagation, 17.7

I

IDAP

message, 17.3, 17.3

schema, 17.4.2, 17.4.2

transmitted over Internet, 17

IDAP. See Internet Data Access Presentation, 1.9.3, 17.2

INIT.ORA parameter, 3.14

Internet

access, 7.12

Advanced Queuing operations, 17.1

Advanced Queuing operations over, 17

AQ operations over, 1.2, 1.9

Internet Data Access Presentation (IDAP), 1.9.3, 17.2

J

JDBC

connection parameters, registering through LDAP, 12.2.3

connection parameters, registering through the database, 12.2.1

connection parameters, topic connection factory, 12.4.4

JDBC URL

registering through LDAP, 12.2.4

registering through the database, 12.2.2, 12.2.2

JMS

Oracle Streams

example, 24.9

JMS Extension, 4.6

JMS Type queues/topics, 1.9.1

JMS types, 1.9.1

JOB_QUEUE_PROCESSES parameter, 3.14.2

L

LDAP

queue/topic connection factory, 12.4.5

queue/topic, getting, 12.5

registering, 12.2.4

unregistering, 12.3.1, 12.3.2

LDAP server

with an AQ XML Servlet, 17.5.5

listen capability, 7.15.2

listener.ora file

modifying, 19.2.2

database objects, 19.2.1

logical change records (LCRs)

constructing

example, 24.4

M

managing

gateway agent, 20.1

map message, 11.2.6

message

fanning-out, 1.7

grouping, 7.13.5

history, 7.8

navigation in dequeue, 7.14.4

ordering, 7.13.2

priority and ordering, 7.13.2, 11.5.1

propagation, 1.7

recipient, 1.4

message array

dequeue, 10.5

enqueue, 10.2

message enqueuing, 10.1

message grouping, 1.11.1, 11.5.4, 11.5.4

message handlers

creating, 24.5

message history and retention, 11.1.6

message navigation in receive, 11.6.2

message payloads, 1.9.1

message_grouping, 3.12

MessageProducer features, 11.5, 11.8

messaging

propagation, 23.3

Messaging Gateway, 18.3.1

administration, 18.3.1

prerequisites for installing, 19.1

Messaging Gateway agent. See gateway agent

MGW_ADMINISTRATOR_ROLE role, 20, 21.1.4

mgw.ora file, 19.2.4

modifying

listener.ora file, 19.2.2

tnsnames.ora file, 19.2.3

multiple recipients, 1.11.2

N

navigation, 3.13

nonpersistent queue, 1.11.4, 2.3.2

creating, 8.2.2

notification, 17.3.11

asynchronous, 7.16

O

object message, 11.2.8

object types, 5.2.1.3

object_name, 3.1, 3.1

optimization

arrival wait, 7.14.6

optimization of waiting for messages, 1.11.2

Oracle Extension, 4.6

Oracle Internet Directory, 17.9.2

Oracle object (ADT) type queues, 1.9.1

Oracle Real Application Clusters, 1.11.4, 7.10, 11.1.7

Oracle Streams

AnyData queues, 23.4

JMS, 23.2.2

example, 24.9

messaging, 23.4

OCI, 23.2.2

P

payload, 1.9.1

structured, 7.6, 7.6

performance, 6.1

priority and ordering of messages, 11.5.1

privileges, 5.2.3

revoking, 2.2.5

privileges. See specific privilege, such as system privilege, topic privilege, 12.9.3

programmatic environments, 4.1

propagation, 1.11.1, 3.14.2, 7.17.1, 11.7, 17.7

exception handling, 11.7.4, 11.8.1

exception handling during, 11.7.4

failures, 5.8.3

features, 7.17

issues, 5.8

LOB attributes, 7.17.3

message, 1.7, 5.2.5

messages with LOB attributes, 7.17.3

processing, 18.4

schedule, 11.7.2

schedule, altering, 12.11.3

schedule, disabling, 12.11.4

scheduling, 1.11.3, 7.17.2, 7.17.2, 7.17.4, 12.11.1

scheduling, enabling, 12.11.2

unscheduling, 12.11.5

using HTTP, 7.17.7

propagation schedule, 11.7.3

altering, 8.6.4

disabling, 8.6.6, 8.6.6

enabling, 8.6.5, 8.6.5

selecting, 9.4

selecting all, 9.4

Propagation, Exception Handling During, 11.8.3

propagations

transformations

SYS.AnyData to typed queue, 23.6, 23.6

publish/subscribe, 7.9

topic, 11.4.1

Q

QMN. See queue monitor (QMN), 1.11.4

queue

altering, 8.2.3, 8.2.3

creating, 8.2.1, 8.2.1

creating, example, 2.2.1

dropping, 8.2.4

nonpersistent, 1.11.4, 2.3.2, 8.2.2

point-to-point, 11.3.1

point-to-point, creating, 12.8.1

selecting all, 9.3

selecting in user schema, 9.9

selecting, in user schema, 9.9

selecting, user has any privilege, 9.5

selecting, user has queue privilege, 9.3

staring, 8.2.5

starting, 8.2.5

stopping, 8.2.6, 8.2.6

subscriber rules, 9.12

subscriber, selecting, 9.11

subscribers, 1.4

subscribers, selecting, 9.11

queue monitor, 1.11.4

queue privilege

granting, 8.4.3

granting, point-to-point, 12.9.5

revoking, 8.4.4

revoking, point-to-point, 12.9.6

queue propagation

scheduling, 8.6.1, 8.6.1

unscheduling, 8.6.2, 8.6.2

queue subscribers

selecting, rules, 9.12

queue table

altering, 8.1.2

creating, 8.1.1, 12.6

creating prioritized message, 8.2.1

creating, example, 8.1.1, 8.1.1, 8.1.1, 8.2.1, 8.2.1

creating, example, XMLType attributes, 8.1.1

dropping, 8.1.3, 8.1.3

getting, 12.7

messages, selecting, 9.7

selecting all, 9.1, 9.1, 9.7

selecting messages, 9.7

selecting user tables, 9.2

queue table data

exporting, 5.3.1

queue tables

creating, example, 2.2.1

selecting all in user schema, 9.8

queue type

verifying, 8.6.3, 8.6.3

queue_type, 3.12

queue-level access control, 1.11.4, 7.4

queues

AnyData, 23.2, 23.4

dequeuing, 24.6

enqueuing, 24.4

user-defined types, 23.3.1

propagation, 23.3

queue/topic

connection factory in LDAP, 12.4.5

connection factory, unregistering in LDAP through the database, 12.3.1

connection factory, unregistering in LDAP through the LDAP, 12.3.2

LDAP, 12.5

R

RAW queues, 1.9.1

Real Application Clusters. See Oracle Real Application Clusters, 1.11.4

receiving messages, 11.6.1

recipient, 1.4

list, 7.13.1, 7.13.1, 11.4.4

local and remote, 1.11.2, 7.14.3, 7.14.3

multiple, 7.14.2, 7.14.2

REF

non-support of payload attribute, 5.7.3

server response, 17.3.8

registering

AQ Agent, 17.5.4.1

JDBC connection parameters through LDAP, 12.2.3

JDBC URL through LDAP, 12.2.4

through the database, JDBC connection parameters, 12.2.1

through the database, JDBC URL, 12.2.2

registration

client request for, 17.3.1

to a queue, 3.7

registration for notification vs. listener, 2.3.2

retention, 3.12

retention and message history, 1.11.4, 1.11.4, 7.8, 11.1.6

retries with delays, 1.11.2

retry

delay interval, 7.14.7

revoking roles and privileges, 2.2.5

role

revoking, 2.2.5

user, 5.2.1.2

rollback a transaction, 17.3.5

rollback response, 17.3.10

rule

selecting subscriber, 9.12

rule-based subscriber, 1.11.1

rule-based subscription, 7.15.1

rules

evaluation contexts

creating, 24.5

S

scheduling

propagation, 1.11.3, 11.7.2, 12.11.1

schema

AQ XML, 17.4

IDAP, 17.4.2

SOAP, 17.4.1

security, 5.2.1, 5.2.2

sender identification, 1.11.1

sequence_deviation, 3.13

servlet

AQ XML, 17.5, 17.5.5

SOAP, 17.4

body, 17.2.1.3

envelope, 17.2.1.1

headers, 17.2.1.2

message structure, 17.2.1

method invocation, 17.2.2

SYS.AnyData queues, 23.3

SOAP schema, 17.4.1

SQL access, 1.11.4

starting

destination, 12.10.1

state parameter, 3.13

statistics views, 7.11

statistics views support, 11.1.8

stopping

destination, 12.10.2

stream message, 11.2.4

structured payload, 1.11.4, 1.11.4, 7.6

structured payload/message types, 11.2

subscriber, 3.6

adding, 8.5.1, 8.5.1

altering, 8.5.2

durable, 11.4.2

removing, 8.5.3, 8.5.3

rule-based, 1.11.1

selecting, 9.11

subscription, 7.13.1

anonymous, 3.8

rule-based, 7.15.1, 7.15.1

subscription and recipient list, 1.11.1

subscription and recipient lists, 1.11.1

SYS.AnyData. See Also AnyData datatype

system privilege

granting, 8.4.1, 8.4.1

revoking, 8.4.2, 8.4.2

system privileges

granting, 12.9.1

system-level access control, 7.3, 11.1.4

T

text message, 11.2.7

time specification, 1.11.1

delay, 7.13.3, 11.5.2

expiration, 7.13.4, 11.5.3

tnsnames.ora file

modifying, 19.2.3

topic

connection factory, JDBC connection parameters, 12.4.4

connection factory, with JDBC URL, 12.4.3

publish/subscribe, creating, 12.8.2

topic privilege

granting, publish/subscribe, 12.9.3

revoking, publish/subscribe, 12.9.4

TopicPublisher, 11.4.3

tracking and event journals, 1.11.4

transaction protection, 1.11.2

transformations

propagations, 23.6, 23.6

tuning. See database tuning, 6.2

type_name, 3.2

types

object, 5.2.1.3

U

unloading

Messaging Gateway, 19.5

unregistering

queue/topic connection factory in LDAP, 12.3.1, 12.3.2

unscheduling

propagation, 12.11.5

user authentication, 17.5.3

user authorization, 17.5.4

user role, 5.2.1.2

USER_ATTRIBUTE_TRANSFORMATIONS, 9.19

USER_TRANSFORMATIONS, 9.18

user-defined datatypes

AnyData queues, 23.3.1

users

administration, 19.2.5

agent, 19.2.6

V

views

statistics, 7.11

visibility, 3.13

W

wait, 3.13

waiting

for message arrival, 7.14.6

X

using with AQ, 5.6

XML, 17

components, 1.9.1

schema, 17.4

servlet, 17.5, 17.5.5

servlet, HTTP, 17.6