Print Thread
"You must supply an object type" error dequeuing
#8711 10/03/06 03:23 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
OP Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
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?


LDS
Re: "You must supply an object type" error dequeuing
#8712 10/03/06 05:21 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
OP Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
Found the problem: the queue name had the wrong owner. But the exception raised is totally misleading!


LDS
Re: "You must supply an object type" error dequeuing
#8713 10/03/06 10:15 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
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.


Marco Kalter
Allround Automations
Re: "You must supply an object type" error dequeuing
#8714 10/04/06 06:11 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
OP Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
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.


LDS
Re: "You must supply an object type" error dequeuing
#8715 10/04/06 10:56 PM
Joined: Aug 1999
Posts: 22,216
Member
Offline
Member
Joined: Aug 1999
Posts: 22,216
We'll consider it. I don't think it can break existing code though, since a DOAError would also be an Exception.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.029s Queries: 12 (0.006s) Memory: 2.5151 MB (Peak: 3.0418 MB) Data Comp: Off Server Time: 2024-05-11 06:11:37 UTC
Valid HTML 5 and Valid CSS