<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have a PL/SQL procedure that will open up a cursor and process records one at a time to load them into another table. &nbsp;I will be processing ~4,000 - 5,000 records per run. &nbsp;I don't want to commit each record, but I also don't want to wait until the end to commit.<br />
<br />
How can I set the commit frequency in my PL/SQL procedure to commit, say, every 500 records?<br />
<br />
Thanks,<br />
Chris
</div>
</div>


Hello,

I have a PL/SQL procedure that will open up a cursor and process records one at a time to load them into another table.  I will be processing ~4,000 - 5,000 records per run.  I don't want to commit each record, but I also don't want to wait until the end to commit.

How can I set the commit frequency in my PL/SQL procedure to commit, say, every 500 records?

Thanks,
Chris

Commit Frequency in PL/SQL

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.