Community
Learn
Tools Library
AI Tools
Leisure
search
English
Home > Database > Mysql Tutorial > Oracle PL/SQL之EXCEPTION -- WHEN OTHERS THEN

Oracle PL/SQL之EXCEPTION -- WHEN OTHERS THEN

WBOY
Release： 2016-06-07 16:46:11
Original
2226 people have browsed it

在处理EXCEPTION时应特别注意WHEN OTHERS THEN的使用，因为WHEN OTHERS THEN会吃掉所有的EXCEPTION。如果在WHEN OTHERS THEN后不

在处理EXCEPTION时应特别注意WHEN OTHERS THEN的使用，因为WHEN OTHERS THEN会吃掉所有的EXCEPTION。如果在WHEN OTHERS THEN后不抛出任何信息，即：WHEN OTHERS THEN NULL; 这可能会极大地增加以后程序排错的难度，因为即使出错了，也没有任何提示。所以我们需要特别留意WHEN OTHERS THEN，除了一个一个的手工查找外，还可以采用如下命令以便在编译时就进行检查：

  • 测试样例：

    linux

    ，
    • Related labels：
    Oracle教程 Oracle PL/SQL之EXCEPTI
    source：php.cn
    Previous article：使用Xtrabackup对MySQL进行备份和恢复 Next article：PostgreSQL数据库创建、删除方法
    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
    Latest Articles by Author
    Latest Issues
    Regular expression filter for MERN stack search boxes and checkboxes I'm trying to understand how the MERN stack works together by learning by doing, and I'm f...
    From 2024-04-06 14:53:12
    0
    1
    425
    How to render data through DOM instead of through table I have a question about an application I'm creating, I'm using an Oracle database and I'm ...
    From 2024-04-04 18:17:27
    0
    1
    3567
    Prestashop installation issue: Unable to install custom module I am new to Prestashop module development. I'm trying to build Amy's first prestashop modu...
    From 2024-04-03 19:24:44
    0
    1
    402
    PHP Tutorial: How to upload text and images to Linkedin using PHP? I try to upload text, images and links using LinkedinsRestAPI (https://learn.microsoft.com...
    From 2024-04-03 18:42:29
    0
    1
    420
    Unable to receive information from my mySQL database despite having seen tutorials doing the exact same thing So I'm trying to make a program that reads and writes to a MySQL database, which led me to...
    From 2024-04-03 14:46:04
    0
    1
    298
    Related Topics
    More>
    Popular Recommendations
    Popular Tutorials
    More>
    Related Tutorials
    Popular Recommendations
    Latest courses
    Latest Downloads
    More>
    Web Effects
    Website Source Code
    Website Materials
    Front End Template