Did you try fetch prior? See http://starlet.deltatelecom.ru/rdb$doc/oraclerdb/gsp7/gus_pro_list_curs.html
2011/1/23 gayathri Dev <gd0...@gmail.com> > hope this can give a lil more picture of what I am doing. > > I am using Index_by_table (tab_user) of type struct_tab_user > > for i in tab_user.first.. tab_user.last loop > if treat(tab_user(i) as struct_tab_user).user_id = 'user5' then > next_user_id := tab_user.next(i); *-- returns NULL, but I want > to loop back and say the next_user is user1* > next_user := treat(tab_user(next_user_id) as > struct_tab_user).user_id ; > end if; > end loop; > > user1, 1 <- Next user > user2, 2 > user3, 3 > user4, 4, > user5, 5. <- input parameter. > > > > > On Sun, Jan 23, 2011 at 10:46 AM, gayathri Dev <gd0...@gmail.com> wrote: > >> Hi All, >> >> Is there a way to loop back? >> >> say if I have a records as below: >> >> user1, 1 >> user2, 2 >> user3, 3 >> user4, 4, >> user5, 5. >> >> and my cursor is pointing to user5, and I have to loop back to first >> record. >> How can i do that in Oracle10g?? >> >> Thanks in advance! >> G >> > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en > -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
