PL/SQL (MOSC)

MOSC Banner

PLSQL Notification not working in Advanced Queueing

edited Dec 17, 2009 1:24AM in PL/SQL (MOSC) 1 commentAnswered
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.

=========================
 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 (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center