PL/SQL cursor

From: <ttran_at_ssofa.com>
Date: 1997/03/26
Message-ID: <859422467.5035@dejanews.com>#1/1

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;

   End Loop;

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

Received on Wed Mar 26 1997 - 00:00:00 CST