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

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?

Mon, 21 Feb 2005 04:56:47 GMT
 [ 1 post ] 

 Relevant Pages 

1. Advance Queuing - move msg to exception queue

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

3. Oracle Advanced Queuing: What to expect?

4. benchmarks on Oracle Advanced Queuing

5. Oracle Advance queue

6. Advanced Queuing question

7. Advanced Queuing , experiences anyone?

8. Using Advanced Queues dynamically

9. Advanced Queuing -- LISTEN

10. Oracle 8 - Advances queuing package.

11. advanced queueing - how to enqueue to remote queue

12. advanced queueing - enque to remote queue

Powered by phpBB® Forum Software