Enumerated Constants in the Administrative Interface

When using enumerated constants such as INFINITE, TRANSACTIONAL, NORMAL_QUEUE are selected as values, the symbol needs to be specified with the scope of the packages defining it. All types associated with the administrative interfaces have to be prepended with dbms_aqadm. For example:

DBMS_AQADM.NORMAL_QUEUE

Table 2-3 Enumerated types in the administrative interface

Parameter	Options
retention	0,1,2...INFINITE
message_grouping	TRANSACTIONAL, NONE
queue_type	NORMAL_QUEUE, EXCEPTION_QUEUE,NON_PERSISTENT_QUEUE