Home » RDBMS Server » Performance Tuning » how do i read new messages in cursor
how do i read new messages in cursor [message #64905] Sun, 29 February 2004 23:22
Messages: 76
Registered: April 1999
I have multi threaded program..

My one of thread is reading data from DB and putting into local buffer.

After that my others threads reading this data from buffer sending to server and after getting response they r updating the DB. After all message sent the reading thread will read new messages and put into buffer while my transmitter threads are blocked..

While sending these messages, reading thread is blocked. So I thought I will have multiple buffers but I am using the same query to read the database so I will get same messages again. Here actually I want read the messages, which are not read in previous cursor.


Please help me.. How do I do this?


pls send mail to my ID vinod_suryan@rediffmail.com


Previous Topic: Limiting the number of hits to 1 with rownum.
Next Topic: Query Results not coming second time
Goto Forum:

Current Time: Wed Feb 28 10:11:20 CST 2024