Thanks for the feedback. Certainly helped the thought process :-) A question with regard to your second suggestion:
How would you go about getting the rows blockwise into the other table? The problem now is that my reader should process all rows, but that the way i'm doing it causes rows to be skipped sometimes. Your proposition seems to suggest that there may be a another solution for reading blockwise from the table without the risk of skipping rows. I was thinking of selecting on rownum instead, so that it would be effectively selecting the rows that were "physically" inserted last in the table. But that has problems, because rownum may changes if the table is re- ordered at a later point. Also it's not easy storing a rownum value as it is it's own special data type (i've tried); --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
