Home » RDBMS Server » Server Administration » Transaction handling from ASP
Transaction handling from ASP [message #54867] Wed, 11 December 2002 06:18 Go to next message
sai
Messages: 27
Registered: October 2001
Junior 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

Report message to a moderator

Re: Transaction handling from ASP [message #54870 is a reply to message #54867] Wed, 11 December 2002 06:57 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
"set autocommit on" 
is exclusive only to sql*plus.
( i believe, in OCI, use of  ocon() will do the same)
so, Issue a COMMIT exclusively in your statments.

Report message to a moderator

Previous Topic: Can't find out the "svrmgrl" file !!!
Next Topic: Snapshot options
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 03:49:43 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.