-
Bulk collect on collections
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;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|