We are just opening the "close cursors on/at commit" specification ;o)
- MS SQL server: cursor_close_on_commit
- Firebird: close_cursors_at_commit
- DB2: "with hold" syntax
- ...
I think it a plus to support keeping opened cursors at commit time,
but impacts have to be checked in details ...
Oracle Ora-1555 error comes in the extreme situation where rows used inside the cursor are modified, commited, before to be fetched.