SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Writing archive procedure in PL/SQL

cubmarNov 1 2008 — edited Nov 2 2008

Hi

I wish to write a fairly simple archiving procedure in PL/SQL

Objective is:

1) SELECT a subset of data to be archived (ie candidates for archive)

2) For each row in the selection above, read the row from the live table, write the row to the archive table, commit, delete the row from the live table, commit

Can someone please get me going on this? I am getting so confused with cursors, fetch, open, loop, rowtype, etc!

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2008

Added on Nov 1 2008

#plsql

6 comments

1,358 views