Unanswered: Oracle AQ Error while reading from AQ Table using Windows Service
Message :ORA-25215: user_data type and queue type do not match. This is an interminent error whenever we try to change the oracle types with adding a additional element and refer as an object in the SYS.AnyDATA function. This error is coming whenver we are trying to enqueue the message from an AQ table to the MQ using the windows service.
In the past this error was resolved by dropping the appropriate Queues and corresponding AQ table and types and re-creating..!! Not sure if this is the right way..Definitly not !!
We have the Oracle 10gR2 on Linux. Any help will be apprciated