Oracle触发异常和回滚可能(Oracle trigger exception and rollback maybe)

 假设我有以下触发器： 
 
create or replace trigger trigInsertSaloane before insert on saloane
for each row
declare
  myExcp exception;
  pragma exception_init (myExcp,-20005);
begin
  for i in (select * from saloane) loop
    if(:new.numar_salon=i.numar_salon) and (trim(upper(:new.nume_sectie))=trim(upper(i.nume_sectie))) then
    raise myExcp;
    end if;
  end loop;
  exception when myExcp then dbms_output.put_line('Record exists');
end;
/
 
 我想要的只是在引发异常时不插入行，所以就像回滚一样。 在我的情况下，如果引发异常并捕获，则还会插入该行。 我不想要那个。 此外，我希望以一种漂亮的方式，通过显示一条消息而不会出现任何错误。如何制作它？ 

Suppose I have the following trigger :
 
create or replace trigger trigInsertSaloane before insert on saloane
for each row
declare
  myExcp exception;
  pragma exception_init (myExcp,-20005);
begin
  for i in (select * from saloane) loop
    if(:new.numar_salon=i.numar_salon) and (trim(upper(:new.nume_sectie))=trim(upper(i.nume_sectie))) then
    raise myExcp;
    end if;
  end loop;
  exception when myExcp then dbms_output.put_line('Record exists');
end;
/
 
All I want is to not insert the row if exception is raised, so something like rollback. In my case if exception is raised and caught, the line is also inserted. I don`t want that. Also I want to make that in a pretty way, by showing up a message and not getting any errors.How to make it?

原文：https://stackoverflow.com/questions/37004165