Recent content by asingh

Hi, Unfortunately they are not using a SELECT ... FOR UPDATE statement. Here is a description of 2 scenarios where the users have encountered this problem. -------------------------------------------------- SCENARIO 1 1/ On one PL/sql developer sql window I was running this statement select...

When two people are logged into the same database and one person has executed a select query on one, many or all records of a table, the other user is unable to update any of the returned values. This can also occur if the one person has two SQL windows connected to the same database and is...

Well the problem is solved. It seems that somehow, the registry settings for Oracle 7 and Oracle 8 had been deleted from the user's computer hence the application was unable to pick up the default Oracle home. Only Oracle 9 was still showing. We simply copied the registry from another user and...

I have tried this prior to re-installing. I deleted all entries for PL-SQL Developer from the registry to ensure it is a 'clean' install. The problem persisted after re-installation.

I do not think that the Oracle client has any problem. This is because other users who have the client can connect to it fine. Even the user who is having problems with it is able to connect to the database from other PCs. It seems there is something in her settings which are not allowing her...

We have had PL/SQL Developer for a while now and it has been woring fine with our Oracle 7.3.4 databases. A user recently installed the Oracle 9i client on her system in preparation for an upgrade of the database to Oracle 9i and PL/SQL Developer would not let her connect to the database. We...