阅读背景:

Oracle 11gR2用于保存数据库视图中不工作的异常

来源:互联网 

I want to take advantage of Oracle bulk DML operation and exception handling. My requirement is to perform DML operation on a database view, where it perform some validations through view trigger, then finally insert/update the underlying table. However, Oracle's FORALL .. SAVE EXCEPTIONS doesn't seem to catch validation error raised in the view. Is this the limitation/restriction of SAVE EXCEPTION where it only work with database table but not view? Oracle documentation doesn't seem to mention this as well. Below are my test codes (based on modification from I want to take advantage of Oracle bulk DML ope




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: