>Resume placed in the procedure gives me' suspend before resume'
>resume placed after the on error gives me 'open tables ' then lists all my tables in tatadase
>note: i'm using the on error after attemp to lock. maybe a sample code could help me out.
>i may be missing out something.

---

It is like someone else answered to me, it's retry instead of resume.
Sorry for the stupid mistake.