Dear All! I have retrieved data form the Database. I want to give Search Utility to move back and forth to view the record. I have given to move the record to Next, but I could not get done for previous record. How do I get it? ------------------ S Arockiaraj
You need to look into scrollable result set. I think the default result set is a forward only cursor. I haven't used a Scrollable result set because the performance is pretty bad (from what I've read). You might want to look into putting the data into a collection and going through the collection rather than using a scrollable result set.