Re: Reflect updates in scroll cursor

This is a problem called stale data. The quickest way araound it is to only select the primary key in the declare cursor and then select the actual data within your loop. Bearing in mind you shouldnt be updating the primary key you should always get the right data. -- Mike Aubury