"You must supply an object type" error dequeuing

[ldsandon]

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?

 

[ldsandon]

Found the problem: the queue name had the wrong owner. But the exception raised is totally misleading!

 

[Marco Kalter]

We'll fix the error message. It is indeed misleading. It is not an EOracleError exception, because it is not raised by Oracle but by the TOracleObject class.

 

[ldsandon]

Thank you.

What about a DOAError exception for those error raised by DOA classes but not Oracle? Would simplify bug hunting - I know it could break existing code.

 

[Marco Kalter]

We'll consider it. I don't think it can break existing code though, since a DOAError would also be an Exception.