Reopening an Insert Cursor

When you reopen an Insert cursor that is already open, you effectively flush the insert buffer; any rows that are stored in the insert buffer are written into the database table. The database server first closes the cursor, which causes the flush and then reopens the cursor. For information about how to check errors and count inserted rows, see Error Checking.

In an ANSI-compliant database, you receive an error code if you try to open a cursor that is already open.