When executing a SELECT statement that calls the queue table AQ_SRVNTFN_TABLE in the SQL Editor Window of TOAD, the following error occurs:
OCI-22303: type "SYS"."AQ$_SRVNTFN_MESSAGE" not found
An example of the query is as follows:
SELECT q_name, state, DELAY, expiration, ROWID, msgid, dequeue_msgid,
chain_no, local_order_no, enq_time, enq_tid, step_no, priority,
exception_qschema, exception_queue, retry_count, corrid,
time_manager_info, sender_name, sender_address, sender_protocol
FROM SYS.aq_srvntfn_table
WORKAROUND:
Execute query in SQL*Plus.
STATUS:
Waiting for fix in a future release of TOAD.
