Re: Strange transactional problem with my Oracle database?

Brad Pybus wrote:

> I'm working with an Oracle database that was not created by me and I'm an
> Oracle newbie. I'm having a wierd problem where when I try to modify or
> delete records in SQLPlus worksheet, the changes don't stick. This happens
> on all the tables. For example, I will delete records in table A, then I do
> a select count(*) to confirm that those certain records were all deleted.
> It shows that they are. So then I exit SQLPlus worksheet, then I come back
> in and then it will show me that none of the records were deleted. Its
> almost as if SQLPlus worksheet starts a transaction the minute I enter it
> and then as soon as I close the SQLPlus worksheet, it rolls back the
> transaction. I tried deleting all the triggers on all the tables just in
> case that was the problem; It wasn't. Is there a setting somewhere that
> would cause this kind of behavior?

Perhaps the concept of the COMMIT has not been explained to you.

Inserting, updating, and deleting do nothing to the database. After they are issued you must either COMMIT (to save the changes to the database) or ROLLBACK (so the changes do not take effect).

Daniel Morgan Received on Fri Aug 23 2002 - 12:35:13 CDT