Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Custom exceptions-always forget exception

2025-04-02 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Create or replace procedure pr_test_def_exception

As

V_error varchar2 (200)

V_cnt varchar2 (200)

V_sal number

EX_RESOURCE_BUSY EXCEPTION

PRAGMA EXCEPTION_INIT (RESOURCE_BUSY,-54)

Begin

-- start another session and execute lock table scott.bonus in exclusive mode

Select sal into v_sal from scott.bonus where ename='majunjie' for update nowait

Update scott.bonus set sal=2000 where ename='majunjie'

Dbms_output.put_line (v_cnt)

Exception

When RESOURCE_BUSY then

V_error: = sqlerrm

Dbms_output.put_line (v_error);-- ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

When others then

V_error: = sqlerrm

Dbms_output.put_line (111)

End

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 221

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report