Task 5: Enqueuing Messages

The example in "Task 3: Configuring a Message Enqueuing Mechanism" created a trigger. The trigger enqueues a message with information about an order that was inserted into the oe.orders table into the strmadmin.streams_queue queue. So, you can enqueue messages into the strmadmin.streams_queue queue by inserting rows into the oe.orders table.

To insert rows into the oe.orders table: 

1. On a command line, open SQL*Plus and connect to the ii1.example.com database as oe user.

   See Starting SQL*Plus and Connecting to the Database for more information about starting SQL*Plus.

2. In SQL*Plus, insert rows into the oe.orders table:

   INSERT INTO oe.orders VALUES(3000, SYSDATE, 'direct', 116, 0, 4000.00, 153, NULL);
    
   INSERT INTO oe.orders VALUES(3001, SYSDATE, 'direct', 117, 5, 5000.00, 163, NULL);
    
   INSERT INTO oe.orders VALUES(3002, SYSDATE, 'direct', 118, 7, 6000.00, 159, NULL);
   

3. In SQL*Plus, commit your changes:

   COMMIT;
   

4. Complete the steps in "Task 6: Dequeuing Messages" to continue this extended example.