1 Reply Latest reply: Feb 18, 2012 4:22 AM by pmcelroy-Oracle RSS

    Can anybody tell us how to write a "simple" PL/SQL to write to a Queue.?

    user12240205
      Hello Gurus,

      We want to perform a relatively simple task. We want to:
           a. create an "Oracle Queue"
           b. Write an image into that queue
           c. In another DB, we read this queue
           d. and get the image.

      I went through lots of Oracle documentation about queuing and also examples

      http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_aq.htm
      http://docs.oracle.com/cd/B10501_01/appdev.920/a96587/apexampl.htm
      http://docs.oracle.com/cd/B19306_01/server.102/b14257/toc.htm

      Unfortunately even the examples are horrendously difficult to grasp and also very lengthy.

      We would be very grateful if anybody could provide us with code to do the above.

      Thanks in advance