In Oracle form created master detail blocks with master block on a view based on master table.
When form is opened in any session, table is getting locked and not able to perform DML from any other session or database on other records.
http://www.orafaq.com/forum/t/
https://asktom.oracle.com/pls/
Solution is to create an index on child table for foreign key column
CREATE INDEX emp_idx1 ON emp(deptno)
When form is opened in any session, table is getting locked and not able to perform DML from any other session or database on other records.
http://www.orafaq.com/forum/t/
https://asktom.oracle.com/pls/
Solution is to create an index on child table for foreign key column
CREATE INDEX emp_idx1 ON emp(deptno)
No comments:
Post a Comment