Hello Experts,
we have a requirement as mentioned below,
Declare
cursor c1 is
select job_id,
job_name
from table1;
cursor c2(i_job_id number)
is
select order_no,
order_item
from table2
where job_number = i_job_id ;
cursor c3(i_ord_no number)
is
select end_ord_no,
end_ord_item
from table3
where order_number = i_ord_no;
v_flag varchar2(1) := 'N';
v_flag1 varchar2(1) := 'N';
v_ord_flag varchar2(1) := 'N';
begin
if v_flag = v_flag1
then
v_ord_flag := 'Y'
else
v_ord_flag := 'N'
end if;
for c1_rec in c1
loop
...
..
for c2_rec in c2(c1_rec.job_id)
loop
...
for c3_rec in c3 (c2_rec.order_no)
loop
if v_ord_flag = 'N' then
...
...
insert into temp_data
values
();
elsif v_ord_flag = 'Y' then
..
..
insert into temp_data
values
();
end if;
end loop;
end loop;
end loop;
commit;
end;
this script is inserting the data when v_ord_flag = 'Y' but when v_ord_flag = 'N' occurs, it's not inserting the data.
please suggest, how to proceed further?
thanks