Re: multiple transactions in table

> I am not in charge of Oracle, but my belief is that the DBA needs to set
> some roles or provileges in order for multiple users to get access to
> tables at the same time.

If this was the case, then you would get an Oracle error saying that the user does not have the specific privileges required to complete the operation (transaction). The application would not freeze up as you have suggested.

> anything else the DBA should set? I am not sure why it's freezing,
> probably because more than 2 or more people are running the program. Any
> suggestions?

This is a locking issue. Two different users are trying to perform the same modifications to a table at the same exact time. This is a no-no. So the second user must wait until the first user is done. You can resolve this issue by taking the time to read the Oracle Application Developer's Guide. Also, is your application committing the changes? If a commit (or rollback) does not take place, then the application will forever hold on to the table and no other users will be able to succesfully use the application.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================