Oracle - Procedure
标签：arc style cep class arch except -- oracl weight
Oracle - Procedure
OR REPLACE PROCEDURE ProcedureName(参数)
as
参数 参数类型;
user_err1 exception; --用户定义异常
ERRSTR varchar2(200);
begin
--业务逻辑
--触发异常提示‘XXXXXX‘
if 条件 then
ERRSTR := ‘XXXXXX‘;
raise user_err1;
end if;
EXCEPTION
WHEN user_err1 THEN
raise_application_error(-20007, ERRSTR);
RAISE;
end;