Has anybody the same problem? Forms6i doesn't release locks on Ora9iSE.

DB - Oracle 9.0.1.1.1 SE on MS WINDOWS 2000 Professional Forms 6.0.8.17.1 (PATCH 8)

Hello,
after upgrading DB from 8.1.7.EE to 9.0.1.SE I get strange behaviour with Forms and Database. It looks like forms doesn't release locks in database.

This is my scenario:

1. User1 open module in Forms which works with table MY_TABLE, then connect to DB and compile (or run and exit) module.
2. after step 1 User2 tries modify table MY_TABLE in SQL*Plus Worksheet by ALTER TABLE MY_TABLE ... . After this, User2 is waiting and after some minutes he gets message ORA-04021: timeout occurred while waiting to lock object SHEMA.MY_TABLE

It looks like Forms lock MY_TABLE and doesn't release this lock. Locks are released after User1 disconnect or his session is killed.

The same module was working fine with DB 8.1.7.EE. The module doesn't use any object type item. MY_TABLE is simple table without object type item or any specification for DB Enterprise Edition.

The same problem is with module based on stored procedure. Forms locks every table which I use in SELECT statement in stored proc.

I don't know if this problem is on Forms side or with database configuration.
Has anybody the same problem?

Thank you for any reply and advice.
Pavel Soukup Received on Wed Jan 30 2002 - 04:35:29 CST