I can no longer browse AQ tables in this version I get an [Error] Execution (1: 15): NET: Net error 99 . This has worked previously and one of my collegues who is running version 25.1 can still browse these table with no problems.
Any error that starts with NET is due to the using Toad without an Oracle client. So, if you connect to the database using an Oracle client this error may go away.
That said, I'd like to be able to reproduce this and fix it. Can you give me a "create table" script for the queue table, and any TYPE/TYPE BODYs that I may need with it?
Thanks
Hi John, sorry it took so long to answer, As you said the problem goes away if I use an oracle client.
Here is a script for the AQ table that cause the problem. the AQ type is Oracle standard that is wrapped
BEGIN
SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
(
QUEUE_TABLE => 'MODC_SYNC_AQS'
,QUEUE_PAYLOAD_TYPE => 'SYS.AQ$_JMS_TEXT_MESSAGE'
,COMPATIBLE => '10.0.0'
,SORT_LIST => 'ENQ_TIME'
,MULTIPLE_CONSUMERS => FALSE
,MESSAGE_GROUPING => 0
,SECURE => FALSE
);
End;
/