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
