orcale存储过程中的异常

create table k (
  k_name varchar2(10) not null,
  k_number number(6)

);





create or replace procedure text_1(s_id in number, s_on out varchar2)

is
ex_my exception;
v_name varchar2(20);

begin

  begin
  
  select k_name into v_name from k where k_number=s_id;
  exception 
  when no_data_found then 
  raise ex_my;
  end;
  commit;
exception
  when ex_my then
  dbms_output.put_line('该数据不存在');
end;

declare
ss varchar(20);
begin
  text_1(1,ss);
end;  
上面有查询异常了，但是我想有个插入的怎么写？

请参考
SQL code

BEGIN   
  select k_name into v_name from k where k_number=s_id;
  exception  
  when no_data_found THEN
  -- 插入数据
  INSERT INTO k_name VALUES('xx', 4);
  raise ex_my;
end;