This is my first loop to create on my own. My code is as follows:
declare
cursor work_order_cur is
select
wo.unit,
itm.code,
wo.loc_code,
wo.work_order,
wo.completed,
dtl.price,
dtl.qty,
dtl.hrs
from
trk_shp_wo wo,
trk_shp_wo_dtl dtl,
trk_shp_item itm
where
wo.completed_flag = 'Y' and
wo.WORK_ORDER = dtl.work_order and
itm.Item_id = dtl.item_id;
v_unit trk_shp_wo.unit%type;
v_code trk_shp_item.code%type;
v_loc_code trk_shp_wo.loc_code%type;
v_work_order trk_shp_wo.work_order%type;
v_completed trk_shp_wo.completed%type;
v_price trk_shp_inv.price%type;
v_qty trk_shp_wo_dtl.qty%type;
v_hrs trk_shp_wo_dtl.hrs%type;
begin
open work_order_cur;
loop fetch work_order_cur into
v_unit,
v_code,
v_loc_code,
v_work_order,
v_completed,
v_price,
v_qty,
v_hrs;
exit when work_order_cur%NOTFOUND;
--this section checks to see if hrs exist if not then do this
begin
if trk_shp_wo_dtl.hrs is null
then
insert into vehicle_cost
(
unit,
cost_code,
loc_code,
invoice_no,
invoice_date,
amount,
qty
)
values
(
v_unit,
v_code,
v_loc_code,
v_work_order,
v_completed,
v_price * v_qty,
'0'
);
--if hrs exist then do this
else
insert into vehicle_cost
(
unit,
cost_code,
loc_code,
invoice_no,
invoice_date,
amount,
qty
)
values
(
v_unit,
v_code,
v_loc_code,
v_work_order,
v_completed,
v_price * v_hrs,
v_hrs
);
end if;
end;
end loop;
close work_order_cur;
end;
When I run it it dies on
"if trk_shp_wo_dtl.hrs is null "
Tell me that it is not allowed in this context.
What I am attempting to do is update another table and I want the firleds it
enters based upon the if statement conditions. I guess my first question is
can you use and IF...THEN...ELSE here or not?
--
H
YIM [EMAIL PROTECTED]
MSN [EMAIL PROTECTED]
"When one teaches, two learn."
Robert Half
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
