0 Replies Latest reply on Oct 16, 2002 4:00 AM by 199442

    Application freezes upon performing insert

    199442
      Well, I think I found my problem and this may be useful to someone else ...
      Basically,it has to do with transactions. When I did an insert into a table, and then follow it with an insert into another table that required a value from the first table to satisfy a foreign key constraint, it locked. This was because I was using a new OraDatabase object to perform the insert, and established the transactions at the OraSession level. I guess in the 8.1.7 client, this does not work. The OraDatabase object manages transactions on it's own, and if you have more than one they cannot "see" each other. The app waits until the table is free, which of course it will not be until you commit the transactions.

      If anyone has any other advice, please let me know.