PL/SQL cursor

[Quoted] [Quoted] Could anyone explain to us where does the PL/SQL cursor data stored? is it in the SGA or else where?

Our archived/purge script looks something like this:

   For C1 in Cursor_1
   Loop

     Process data (insert into archive tables and delete from tables)
     commit;

Notice: the commit command is in the loop. Also this script constantly getting error: Snapshot too old and rollback segment too small.

Thanks in advance, any help will be appreciated.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet