Originally posted by tamilselvan
The syntax is wrong.
It should be
EXECUTE DBMS_AQADM.DROP_QUEUE_TABLE (queue_table => 'DEF$_AQCALL');
This is exactly the same syntax as Raff is using. The only difference is that you are using named parameter notation while he is using positional notation. But appart from this "cosmetic" difference both shold behave exactly the same.

Raff, are you sure DEF$_AQCALL is indeed a queue table? Does it show up when you isue the following query:

SELECT * FROM DBA_QUEUE_TABLES WHERE OWNER = 'TEST';

You've said the query on DBA_OBJECTS returns an object with object name 'DEF$_AQCALL' under schema TEST. But of what type is this object? I suspect you have a queue (not queue table) defined under schema TEST, but the queue table for this queue is actualy in some other schema. So what you actually want to drop from schema TEST is QUEUE, not QUEUE TABLE. For this you should use DBMS_AQADM.DROP_QUEUE procedure.