In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.