Transaction handling through Front End.. [message #23460] |
Wed, 11 December 2002 06:16 |
sai sreenivas jeedigunta
Messages: 370 Registered: November 2001
|
Senior Member |
|
|
hello all,
our front end is ASP
Backend oracle 8.1.7
When our application inserts a record into the database, and immediately tries to retrieve the record the record is not coming, as it was not yet commited.
What is the best way to handle this problem.. ?
also please tell me how to set the Autocommit to ON in the init.ora file..
thanks and Regards
sai
|
|
|
Re: Transaction handling through Front End.. [message #23465 is a reply to message #23460] |
Wed, 11 December 2002 11:02 |
Todd Barry
Messages: 4819 Registered: August 2001
|
Senior Member |
|
|
There is no concept of autocommit in Oracle (how a tool like SQL*Plus handles it is a different issue).
If you are trying to retrieve the row in the same session that did the insert, you will be able to see it prior to the commit. If you are trying to see the inserted row from another session, you will have to commit in the original session so other sessions can see the new data.
|
|
|