Re: Unlocking Locked records

From: Pete Bretz <pete_at_haleypro.com>
Date: Thu, 11 Mar 1999 13:36:42 -0500
Message-ID: <36E80D3A.74486F8D@haleypro.com>

I am not executing a commit in the PL/SQL program which is accessing the records. I have a number of procedures which access the database, and only just recently did I start seeing this record locking problem develop.

Pete

Denny Koovakattu wrote:

> A commit or rollback should free the locked records. Is the user commiting
> after he's done modifying ?
>
> Denny
>
> In article <36E7E357.2A4BDD0A_at_haleypro.com>,
> Pete Bretz <pete_at_haleypro.com> wrote:
> > I'm running Workgroup Server 7.3.4 in a web application environment -
> > Oracle webserver 2.1.1. I am having problem with one table developing
> > locked rows, even though the user is done modifying records. Any
> > suggestions on:
> >
> > 1. how do I clear the locked records
> > 2. troubleshoot why they are remaining locked in the first place.
> >
> > Thanks for any help!
> >
> > Pete Bretz
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 11 1999 - 12:36:42 CST