| urgent: can i see rows_processed by pl/sql block [message #62438] |
Thu, 22 July 2004 00:01 |
BhavinShah
Messages: 105
Registered: February 2004
|
Senior Member |
|
|
hi friends,
i have following block but i could not find no of rowsprocessed by this block.. can i see from data dictionary..
view v$sqlarea is giving no. of rowsprocessed of sql_text only no a pl/sql block.
Declare
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 mf_matrl_new
and mm_qty_hand> 0
group by mm_matcode;
Begin
for i in c1 loop
update nonmoving.all_masters set qty_hand=qty_hand+i.mm_qty_hand,val_hand=val_hand+i.mm_val_hand where
matcode=i.mm_matcode;
end loop;
commit;
end;
pl.. give reply as early as posssible..
bye..
thax
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
