Commit during insert

From: GREGORY KNESER <gregoryk_at_futures.wharton.upenn.edu>
Date: 15 Aug 2001 20:54:20 GMT
Message-ID: <9lenhs$o8p$1@netnews.upenn.edu>

Hello,

I need some help creating an ETL like script.

I'm going to pull data from a remote table, insert it into a local table, and I want to perform commits and give updates to the user along the way to let them know how far it is in the process. Is there some way to pass a hint or set some parameter so that Oracle will commit after X rows have been inserted? I can figure out reporting to the user if this first problem is taken care of.

Thanks,
Greg Received on Wed Aug 15 2001 - 15:54:20 CDT