exception.sql

来自「学习PL/SQL时收集的一些经典的SQL源代码」· SQL 代码 · 共 11 行

create or replace procedure my_exception(i number,j number)
is
  e_my EXCEPTION;
BEGIN
  if (i=j) then	
	  RAISE e_my;
EXCEPTION
  WHEN e_my THEN
 	dbms_output.put_line('There is exception occured defined by me.');
END;
/