create or replace procedure addnaire(p1 in varchar2,p2 in varchar2,p3 in varchar2,p4 in date,v_id out number) as begin insert into naire(col1,col2,col3,col4) values (p1,p2,p3,p4); commit; select id into v_id from naire where col1=p1 and col2=p2 and col3=p3 and col4=p4; end; /
as
begin
insert into naire(col1,col2,col3,col4) values (p1,p2,p3,p4);
commit;
select id into v_id from naire where col1=p1 and col2=p2 and col3=p3 and col4=p4;
end;
/