function insert_chk(code_in in varchar2,data_in in varchar2)
return varchar2;
is
v_count varchar2(10);
begin
select count(1) into v_count from tname where code = code_in and data = data_in;
if v_count>=1 then
return '找到相同记录!';
else
insert into tname(code,data) values(code_in,data_in);
commit;
return '手稿成功!';
end if;
end insert_chk;