Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_AQ, 16 of 24
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 an raw payload enqueue then this PL/SQL callback must have the following signature:
procedure plsqlcallback( context OUT RAW, reginfo OUT SYS.AQ$_REG_INFO, descr OUT SYS.AQ$_DESCRIPTOR, payload OUT RAW, payloadl OUT NUMBER);
Attribute | Description |
---|---|
context |
Specifies the context for the callback function that was passed by |
reginfo |
|
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 a ADT payload enqueue, the PL/SQL callback must have the following signature:
procedure plsqlcallback( context OUT RAW, reginfo OUT SYS.AQ$_REG_INFO, descr OUT SYS.AQ$_DESCRIPTOR, payload OUT VARCHAR2, payloadl OUT NUMBER);
Subprograms | Description |
---|---|
|
Adds a message to the specified queue. |
|
Dequeues a message from the specified queue. |
|
Listen to one or more queues on behalf of a list of agents. |
REGISTER Procedure |
Register for message notifications |
UNREGISTER Procedure |
Unregister a subscription which turns off notification |
POST Procedure |
Posts to a anonymous subscription which allows all clients who are registered for the subscription to get notifications. |
BIND_AGENT Procedure |
Creates an entry for an AQ agent in the LDAP directory |
UNBIND_AGENT Procedure |
Removes an entry for an AQ agent from the LDAP directory |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|