My PC suddenly got off while using forms through application. When again i restart MY PC the form get hang, after i checked with DBA the table is locked after removing table lock the forms got success.

My PC suddenly got off while using forms through application. When again i restart MY PC the form get hang, after i checked with DBA the table is locked after removing table lock the forms got success.

How to avoid the table Lock.??? Pls suggest me a solution.

This is a hard situation to avoid. If your PC hung, GPF'd, etc, and you had an active Forms Session, then you will likely have a lock on a table. The lock is still there because you still have an active Forms session open on the application server and in the database. The application server should close inactive Forms sessions after a period of inactivity (typically 15 minutes) which in turn will release the lock on the table. The only way to prevent this type of lock occurring would be to prevent your PC or Forms Session from abnormal terminations - good luck with this...

When a Forms session terminates abnormally, the only options are to kill the session on the application server or on the database in order to release the table lock.

It mean user have to wait for 15 min for releasing the table lock?. We need immediate to release the table lock.

You will have to figure out a way to identify hung sessions or change the default inactivity timeout to a shorter time. I don't recommend doing this because you will only aggravate your users if they have to log into the system every 5 minutes. I can't image you have users who's computers lock-up on them with great frequency...if you do, you have bigger problems than the 15 minute timeout. The easiest option is for these users to simply contact your App Server admin who can go into the Enterprise Manager console and terminate the hung session or you have have the session terminated in the db.

We are doing barcode scan with this form. From main form we are selecting a values from LOV and we are calling the call form. Calling form with will do barcode scan before saving that number if PC got shutdown again we opened with the particular number the system got Hang . Other number will working fine.