请参考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;
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;
create or replace procedure text_1(s_id in number, s_on out varchar2) is
v_name varchar2(20);
begin
select k_name into v_name from k where k_number = s_id;
exception
when no_data_found then
insert into k (k_name, k_number) values (s_on,s_id);
end;