PLSQL Notification not working in Advanced Queueing
Hi All,
In my database PLSQL Notification not working in Advanced Queueing. The same code is working on another database which is the same version (11.1.0.7). All the init parameters are also same between the two databases. I don't understand why this is not working one database and not in another database. There are NO files generated in udump or bdump.
has any one come across this? kindly help.
this is code i have used. thank you in advance.
( message VARCHAR2(4000) );
/
CREATE TABLE demo_queue_message_table
( message VARCHAR2(4000) );
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE (
In my database PLSQL Notification not working in Advanced Queueing. The same code is working on another database which is the same version (11.1.0.7). All the init parameters are also same between the two databases. I don't understand why this is not working one database and not in another database. There are NO files generated in udump or bdump.
has any one come across this? kindly help.
this is code i have used. thank you in advance.
=========================CREATE TYPE demo_queue_payload_type AS OBJECT
( message VARCHAR2(4000) );
/
CREATE TABLE demo_queue_message_table
( message VARCHAR2(4000) );
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE (
0