ITPub博客

首页 > 应用开发 > IT综合 > Transaction Control Statements in Autonomous Blocks (152)

Transaction Control Statements in Autonomous Blocks (152)

原创 IT综合 作者:tsinglee 时间:2007-11-06 15:00:32 0 删除 编辑

Transaction control statements in an autonomous PL/SQL block apply only to the
currently active autonomous transaction. Examples of such statements are:
SET TRANSACTION
COMMIT
ROLLBACK
SAVEPOINT
ROLLBACK TO SAVEPOINT
Similarly, transaction control statements in the main transaction apply only to that
transaction and not to any autonomous transaction that it calls. For example, rolling
back the main transaction to a savepoint taken before the beginning of an autonomous
transaction does not undo the autonomous transaction.

自治事务中的事务控制恐惧
1. 自治PL/SQL块中的事务控制语句仅对当前的自治事务有效.这些控制语句包括...
2. 主事务中的事务控制语句仅对自身有效 , 不会作用于调用的自治事务

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10599713/viewspace-980977/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
  • 博文量
    740
  • 访问量
    1892919