oracle exception others,ORA-01013 EXCEPTION WHEN OTHERS - Undokumented Behavior?

Hi!

I tried searching everywhere to find some documentation about this, but I couldn't, so I'm asking here:

As far as I can understand the Oracle Documentation EXCEPTION WHEN OTHERS should catch all unhandled Exceptions!!!

But then I stumbled upon ORA-01013 which is User Cancelled... And which just slips right through WHEN OTHERSDECLARE
  e_cancelled EXCEPTION
;
  PRAGMA EXCEPTION_INIT
(e_cancelled, -1013);BEGINBEGIN
    RAISE e_cancelled
;
  EXCEPTION
WHEN OTHERS THEN

      -- All Exceptions should be logged here, but starting with Patch 11.2.0.4.0

       -- WHEN OTHERS is NO LONGER TRIGGERED :-o what to do???
      DBMS_OUTPUT
.PUT_LINE('EXCEPTION OTHERS');END;
EXCEPTION
WHEN e_cancelled THEN

    -- The Exception has to be handled individually
    DBMS_OUTPUT
.PUT_LINE('EXCEPTION CANCELLED');END;/

My research brought me to the Oracle Changelogs, which show with the latest update "ORA-01013 is not catched by WHEN OTHERS anymore"

My Question:

We use detailed error-logging and tracing in our database, catching logging and reraising all errors with "WHEN OTHERS"

is there any Setting or parameter to let the WHEN OTHERS handler catch this exception, or will I have to change hundreds

of packages to insert an additional WHEN ORA-01013 into every method???

Aside from Error-logging, what is with closing of cursors, releasing of ressources ??? Because there is no finally-block in

PL/SQL I usually use BEGIN, EXCEPTION, END like a try-catch block and cleanup after the exception block, but when

a timeout occurs, all that cleanup code will simply be skipped???

Message was edited by: FalcoW

Inserted Link to Oracle Changelog for a better understanding when the change occured...

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值