Oracle RAISE_APPLICATION_ERROR应用

跳跃生命线

于 2025-06-18 11:54:10 发布

阅读量397

点赞数 4

CC 4.0 BY-SA版权

分类专栏： #Oracle #PLSQL 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/AlexLiu_2019/article/details/148736843

Oracle RAISE_APPLICATION_ERROR应用

Summary: in this tutorial, you will learn how to use the procedure raise_application_error to issue user-defined error messages.

Introduction to raise_application_error procedure
The procedure raise_application_error allows you to issue a user-defined error from a code block or stored program.

By using this procedure, you can report errors to the callers instead of returning unhandled exceptions.

The raise_application_error has the following syntax:

raise_application_error(
error_number,
message
[, {TRUE | FALSE}]
);
Code language: PostgreSQL SQL dialect and PL/pgSQL (pgsql)
In this syntax:

The error_number is a negative integer with the range from -20999 to -20000.
The message is a character string that represents the error message. Its length is up to 2048 bytes.
If the third parameter is FALSE, the error replace