User-defined exception (default RAISE_APPLICATION_ERROR)
使用 RAISE_APPLICATION_ERROR 和默认错误号 -20000 引发了用户定义的异常。
SELECT object_name, object_type FROM dba_objects WHERE object_type IN ('PROCEDURE','FUNCTION','TRIGGER','PACKAGE BODY') AND status = 'VALID';SELECT text FROM dba_source WHERE UPPER(text) LIKE '%RAISE_APPLICATION_ERROR%' AND UPPER(text) LIKE '%-20000%';