Oracle9i笔记1(25)

If the exception is handled in the calling procedure, all DML statements in the calling procedure and in the called procedure reaming as part of the transaction.

If the exception is unhandled in the calling procedure, the calling procedure terminates and the exception propagates to the calling environment. All the DML statements in the calling procedure and the called procedure are rolled back along with any changes to any host variables. The host environment determines the outcome for the unhandled exception.

當子過程中出現一個異常時，會提交到子過程的異常處理。如果沒子過程沒有定義異常處理，子過程結束，異常被提交到主程序的異常處理。另外，子程序的命令不會返回到未執行狀態。

如果主過程中定義了異常，所有主過程和子過程中的DML語句，保留部分的數據交換。

搜索“diyifanwen.net”或“第一范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，第一范文网，提供最新人文社科Oracle9i笔记1(25)全文阅读和word下载服务。