CREATE_QUEUE_TABLE v16
Use the CREATE_QUEUE_TABLE
procedure to create a queue table. The signature is:
Parameters
queue_table
The (optionally schema-qualified) name of the queue table.
queue_payload_type
The user-defined type of the data that's stored in the queue table. To specify a RAW
data type, you must create a user-defined type that identifies a RAW
type.
storage_clause
Use the storage_clause
parameter to specify attributes for the queue table. Only the TABLESPACE
option is enforced. All others are accepted for compatibility and ignored. Use the TABLESPACE
clause to specify the name of a tablespace in which to create the table.
storage_clause
can be one or more of the following:
storage_option
can be one or more of the following:
sort_list
sort_list
controls the dequeueing order of the queue. Specify the names of the columns to use to sort the queue in ascending order. The currently accepted values are the following combinations of enq_time
and priority
:
enq_time, priority
priority, enq_time
priority
enq_time
multiple_consumers
multiple_consumers
queue tables isn't supported.
message_grouping
If specified, message_grouping
must be NONE
.
comment
Use the comment
parameter to provide a comment about the queue table.
auto_commit
auto_commit
is accepted for compatibility but is ignored.
primary_instance
primary_instance
is accepted for compatibility and stored but is ignored.
secondary_instance
secondary_instance
is accepted for compatibility but is ignored.
compatible
compatible
is accepted for compatibility but is ignored.
secure
secure
is accepted for compatibility but is ignored.
Example
The following anonymous block first creates a type (work_order
) with attributes that hold a name (a VARCHAR2
), and a project description (a TEXT
). The block then uses that type to create a queue table:
The queue table is named work_order_table
and contains a payload of a type work_order
. A comment notes that this is the Work order message queue table
.
- On this page
- Parameters
- Example