Oracle9i Supplied PL/SQL Packages and Types Reference Release 2 (9.2) Part Number A96612-01 |
|
DBMS_AQ, 2 of 3
Data Structures |
---|
The object_name
data structure names database objects. It applies to queues, queue tables, agent names, and object types.
object_name := VARCHAR2; object_name := [<schema_name>.]<name>;
Names for objects are specified by an optional schema name and a name. If the schema name is not specified, the current schema is assumed. The name must follow object name guidelines in the Oracle9i SQL Reference with regard to reserved characters. Schema names, agent names, and object type names can be up to 30 bytes long. Queue names and queue table names can be up to 24 bytes long.
The type_name
data structure defines queue types.
type_name := VARCHAR2; type_name := <object_type> | "RAW";
The plsqlcallback
data structure specifies the user-defined PL/SQL procedure, defined in the database to be invoked on message notification.
If a notification message is expected for a RAW
payload enqueue, then the PL/SQL callback must have the following signature:
procedure plsqlcallback( context IN RAW, reginfo IN SYS.AQ$_REG_INFO, descr IN SYS.AQ$_DESCRIPTOR, payload IN RAW, payloadl IN NUMBER);
Attribute | Description |
---|---|
context |
Specifies the context for the callback function that was passed by |
reginfo |
See "AQ$_REG_INFO Type". |
descr |
|
payload |
If a notification message is expected for a raw payload enqueue then this contains the raw payload that was enqueued into a non persistent queue. In case of a persistent queue with raw payload this parameter will be null. |
payloadl |
Specifies the length of |
If the notification message is expected for an ADT payload enqueue, the PL/SQL callback must have the following signature:
procedure plsqlcallback( context IN RAW, reginfo IN SYS.AQ$_REG_INFO, descr IN SYS.AQ$_DESCRIPTOR, payload IN VARCHAR2, payloadl IN NUMBER);
|
Copyright © 2000, 2002 Oracle Corporation. All Rights Reserved. |
|