Oracle8i Application Developer's Guide - Advanced Queuing
Release 2 (8.1.6)

Part Number A76938-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Basic Components, 4 of 6


Enumerated Constants in the Operational Interface

When using enumerated constants such as BROWSE, LOCKED, REMOVE, the PL/SQL constants need to be specified with the scope of the packages defining it. All types associated with the operational interfaces have to be prepended with dbms_aq. For example:

DBMS_AQ.BROWSE
Table 2-4 Enumerated types in the operational interface
Parameter  Options 

visibility 

IMMEDIATE, ON_COMMIT 

dequeue mode 

BROWSE, LOCKED, REMOVE, REMOVE_NODATA 

navigation 

FIRST_MESSAGE, NEXT_MESSAGE, NEXT_TRANSACTION 

state 

WAITING, READY, PROCESSED, EXPIRED 

sequence_deviation 

BEFORE, TOP 

wait 

FOREVER, NO_WAIT 

delay 

NO_DELAY 

expiration 

NEVER 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index