I have a procedure

create or replace proc1(param1 in out number,
param2 varchar2,
param3 table_emp_proj)
as

for i in param3.first..param3.last loop
update emp
set proj_id=param3(i).proj_id,
proj_name=param3(i).proj_name,
dept=param1
where emp_id=param3(i).emp_id
and location=param3(i).location;
if sql%rowcount=0 then
insert into emp
values
(emp_id, proj_id, proj_name,location, dept);
end loop;