Advanced Queuing: ORA-25215 user_data type and queue type do not match

Advanced Queuing: ORA-25215 user_data type and queue type do not match

Post by Tomasz Romanows » Fri, 06 Sep 2002 05:56:47

Here is what I'm doing on Solaris 8 with Oracle 9i.

1. In the database I create the object type for the queue payload, the
queue table, and the queues.
2. Using OTT compiler generate the *.h file containing the
C-representation of the oracle and the *.inp file. The *.inp file is
passed as additional input to PROC when compiling the *.pc file
containing enqueue/dequeue operations.
3. Compile the application, run-it, works fine.

Now if I create all the relevant queue objects in another database and
attempt to run the application against this one, the behaviour is
somewhat inconsistent. When attempting to enqueue/dequeue in 1 out of
ten cases I get this error "ORA-25215 User data_type and queue type do
not match".

Any ideas? Does it sound like an Oracle bug in AQ?


1. Advance Queuing - move msg to exception queue


I'm using Oracle Advance Queuing mechanism.
I'm dequeuing msg from a queue, and after checking it I, sometimes,
want to rollback changes but move msg to exception queue.
I cant just rollback dequeue, browse msg and rollback until it goes to
exception queue because I have multiple consumers (they dont share
messages between them, any message is enqueued just by one consumer)
and when I roll it back other consumers may 'take over it'.

does any one have any solution to this problem?


Sent via
Before you buy.

2. Getting the total times

3. how to see time spent in ready queue and wait queue

4. 6.5 writelog timeout & waittypes

5. Oracle Advanced Queuing: What to expect?

6. Calling DLL

7. benchmarks on Oracle Advanced Queuing

8. Telephone Answering Software

9. Oracle Advance queue

10. Advanced Queuing question

11. Advanced Queuing , experiences anyone?

12. Using Advanced Queues dynamically

13. Advanced Queuing -- LISTEN