| want to monitoring a pl/sql block [message #62414] |
Wed, 21 July 2004 01:11  |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
hi.. friends i have following pl/sql code .. and now i have to monitor this code..
Declare
/* curosr for locn kkl*/
cursor c1 is select mm_matcode,sum(nvl(mm_qty_hand,0)) mm_qty_hand ,sum(nvl(mm_val_hand,0)) mm_val_hand
from kkljun.mf_matrl
where substr(mm_matcode,1,2) <> '00'
group by mm_matcode;
/* cursor for chn*/
cursor c2 is select mm_matcode,sum(nvl(mm_qty_hand,0)) mm_qty_hand ,sum(nvl(mm_val_hand,0)) mm_val_hand
from chnjun.mf_matrl
where substr(mm_matcode,1,2) <> '00'
group by mm_matcode;
/* cursor for rjy*/
cursor c3 is select mm_matcode,sum(nvl(mm_qty_hand,0)) mm_qty_hand ,sum(nvl(mm_val_hand,0)) mm_val_hand
from rjyjun.mf_matrl
where substr(mm_matcode,1,2) <> '00'
group by mm_matcode;
/
Begin
for a in c1 loop
update nonmoving.all_masters set qty_hand=qty_hand+a.mm_qty_hand,val_hand=val_hand+a.mm_val_hand where
matcode=a.mm_matcode;
commit;
end loop;
for b in c2 loop
update nonmoving.all_masters set qty_hand=qty_hand+b.mm_qty_hand,val_hand=val_hand+b.mm_val_hand where
matcode=b.mm_matcode;
commit;
end loop;
for c in c3 loop
update nonmoving.all_masters set qty_hand=qty_hand+c.mm_qty_hand,val_hand=val_hand+c.mm_val_hand where
matcode=c.mm_matcode;
commit;
end loop;
End;
here kkl,rjy,chn is my location.. now i want to see upto which location my block is executed..
thax.
bhavin
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
