|
|
Methods
start
This method is used to enable enqueue and dequeue on this queue.
startEnqueue
This method is used to enable enqueue on this queue. This is equivalent to start(TRUE, FALSE)
startDequeue
public void startEnqueue() throws AQException
This method is used to enable dequeue on this queue. This is equivalent to start(FALSE, TRUE).
stop
This method is used to disable enqueue/dequeue on this queue.
stopEnqueue
public void stopEnqueue(boolean wait) throws AQExceptionThis method is used to disable enqueue on a queue. This is equivalent to stop(TRUE, FALSE, wait).
stopDequeue
public void stopDequeue(boolean wait) throws AQExceptionThis method is used to disable dequeue on a queue. This is equivalent to stop(FALSE, TRUE, wait).
drop
public void drop() throws AQExceptionThis method is used to drop a queue
alterQueue
public void alterQueue(AQQueueProperty property) throws AQExceptionThis method is used to alter queue properties
addSubscriber
This method is used to add a subscriber for this queue.
removeSubscriber
public void removeSubscriber(AQAgent subscriber) throws AQExceptionThis method removes a subscriber from a queue.
alterSubscriber
public void alterSubscriber(AQAgent subscriber,java.lang.String rule) throws AQExceptionThis method alters properties for a subscriber to a queue.table9
grantQueuePrivilege
This method is used to grant queue privileges to users and roles. The method has been overloaded. The second implementation is equivalent to calling the first implementation with grant_option = FALSE.
revokeQueuePrivilege
This method is used to revoke a queue privilege.
schedulePropagation
This method is used to schedule propagation from a queue to a destination identified by a database link.
unschedulePropagation
This method is used to unschedule a previously scheduled propagation of messages from the current queue to a destination identified by a specific database link.
alterPropagationSchedule
This method is used to alter a propagation schedule.
enablePropagationSchedule
public void enablePropagationSchedule(java.lang.String destination)This method is used to enable a propagation schedule.
disablePropagationSchedule
public void disablePropagationSchedule(java.lang.String destination)This method is used to disable a propagation schedule.
Examples
Set up the test_aqjava class. For more information, see "Setup for oracle.AQ Examples"
1. Create a queue and start enqueue/dequeue
2. Create a multi-consumer queue and add subscribers
|
|
Oracle 9i Related Tutorials |
|
---|---|
Oracle 10g Tutorial | Oracle 8i Tutorial |
Informatica Tutorial | Oracle 11g Tutorial |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.