Re: Forms 4.5 Problem (Record Locking)
From: <zsirotic_at_my-deja.com>
Date: 2000/04/21
Message-ID: <8dpr4b$e44$1_at_nnrp1.deja.com>#1/1
Date: 2000/04/21
Message-ID: <8dpr4b$e44$1_at_nnrp1.deja.com>#1/1
I work with Forms 5.0 (but this behavior must be the same in Forms 4.5). In Forms 5.0 you can't release record locks with CLEAR_RECORD or CLEAR_BLOCK. Only CLEAR_FORM (or COMMIT_FORM) releases locks.
Oracle RDBMS (and standard SQL) can release record locks only with COMMIT, ROLLBACK or (nonstandard) ROLLBACK TO SAVEPOINT. Releasing only one (non-last) record lock is not possible.
Regards
Zlatko Sirotic
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Apr 21 2000 - 00:00:00 CEST