Re: Advanced Queuing: Messages not deleted until...

Do a commit in SQLPlus. That should send the messages right away.

I have a problem too though, I can't get my VB app to do a monitorstart. I get an automation error. Do you have sample code of the NotifyMe class that receives the notification from the server.

Thanks,
Pete

tenmuc_at_onlinehome.de (Michael) wrote in message news:<e5a603fb.0208090630.65c7c0ef_at_posting.google.com>...
> Hi oracle cracks,
>
> I created a message queue in Oracle 8.1.7 and two users, one who can
> enqueue massages, one who dequeues them.
> I also wrote a procedure to send the messages.
>
> I enqueue the messages in SQL Plus by calling the procedure, I read
> them in a VB application with oo4o MonitorStart.
> All the messages are shown. All this works fine, BUT:
>
> As long as the SQL Plus is runnning, the messages in the queue are not
> deleted and read again and again when I restart the monitor.
> If I disconnect the enqueuing user and close SQL Plus the read
> messages are 'deleted' as predicted with state=3.
>
> Same behaviour if I write a table trigger sending messages. Updateing
> the table in MS Access (linked table) does send messages, but the
> messages are marked read only if I close Access.
>
> Any suggestions?
>
> Thx in advance
> Mike
Received on Tue Aug 20 2002 - 19:54:08 CEST