I am getting this message while attempting to dequeue. Delphi 7, DOA 4.7.0.1, Oracle 10.1.0.5
My queue is created as follows:
dbms_aqadm.create_queue_table(
queue_table => 'VEGA_HTTP_QUEUE',
storage_clause => 'TABLESPACE &QUEUE_TBS',
sort_list => 'PRIORITY,ENQ_TIME',
comment => 'Vega HTTP pages queue',
multiple_consumers => FALSE,
queue_payload_type => 'RAW');
dbms_aqadm.create_queue (
queue_name => 'VEGA_HTTP',
queue_table => 'VEGA_HTTP_QUEUE');
1) What triggers it? The queue uses a RAW payload type.
2) Why the exception is an Exception type and not an EOracleError type?