Unless you require the cursor after the transaction, it is best to close the cursor when the commit operation is carried out.
除非您在事务结束后还需要该游标,否则您最好在执行提交操作后将其关闭。
The locks are released when the process ends or when a commit operation releases locks that were acquired during a unit of work (UOW).
当进程结束,或者当提交操作释放在工作单元(unitof work,UOW)期间获得的锁时,锁就被释放。
By default, the AUTOCOMMIT mode is on, and any data-modification process causes a commit operation to be performed - which, by default, closes any open cursors.
默认情况下,AUTOCOMMIT处于启用状态,并且所有数据修改过程都将导致执行一次提交操作——该操作在默认情况下将关闭所有打开的游标。
A UOW is a recoverable sequence of operations within an application process; it ends as a result of a commit operation, a rollback operation, or the end of the application process.
UOW是应用程序进程中的一个可恢复的操作序列;它由于提交操作、回滚操作或者结束应用程序进程而结束。
A UOW is a recoverable sequence of operations within an application process; it ends as a result of a commit operation, a rollback operation, or the end of the application process.
UOW是应用程序进程中的一个可恢复的操作序列;它由于提交操作、回滚操作或者结束应用程序进程而结束。
应用推荐