I have an Oracle form (F1) with a databse data-block on it, this data-block has been built from table T1 (for example). I also have a package (P1) which tries to update the table T1.
When my users open the form (even without making any changes in it), the process would hang untill the users leave the form. P1 is run from Application Manager.
I changed the locking-mode on the forms from "automatic" till "delayed", but it doesn't solve my issue. Does anyone have an idea?!
many thanks!
I had a cursor with "for update nowait". Removing this, solved my problem.