hi in the above stored procedure i found that
AT folllwing statement it is hanging.
can tell why it hangs here?
should i replace this query?

SELECT COUNT(*) INTO BCOUNT from vam_ledger WHERE party = tparty and vchtype in('BA','CA') AND
VCHNO = C2.VCHNO