Advanced Queuing: ORA-25215 user_data type and queue type do not match
From: Tomasz Romanowski <tromanow_at_hotmail.com>
Date: 4 Sep 2002 13:56:47 -0700
Message-ID: <84e67408.0209041256.553ba00_at_posting.google.com>
Date: 4 Sep 2002 13:56:47 -0700
Message-ID: <84e67408.0209041256.553ba00_at_posting.google.com>
Here is what I'm doing on Solaris 8 with Oracle 9i.
- In the database I create the object type for the queue payload, the queue table, and the queues.
- 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.
- 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? Received on Wed Sep 04 2002 - 22:56:47 CEST