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

I had a similiar problem, where sessions would persist after closing SQL-Plus. It was resolved by upgrading windows 2000 to sp2.

Pavel Soukup wrote:

>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 Mon Feb 04 2002 - 06:41:03 CET