hi, here vam_ledger is a view with total no of rows above one lack.
the underlying table is led_temp.

using Toad tool i observed in the option viewing locks.
the statement

'select count(*) into btotal from vam_ledger ....................
...........

is shown continuesly for long time after running the procedure.

if u get any idea now plz give solution.