Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Auto Commit

Auto Commit

From: <faheemrao_at_my-deja.com>
Date: Thu, 14 Dec 2000 18:06:06 GMT
Message-ID: <91b267$520$1@nnrp1.deja.com>

My problem is that I am trying to convert the backend of a huge application in C++ from a database eingine to Oracle.The thing is that the old database does not have commit facility now , I have to issue a commit command after every DML statement, but the code is tooo lenghty that it is not feasible to write a commit statement every place in the code , I am just wondering that if Oracle Provides the facilty of auto Commit.
I know in sql plus there is a option for auto commit but , does it work if I put the autocommit= on variable in init.ora file?

Or if there is any other way , my code is communicating through Microsoft ODBC driver for oracle.

Any batter solution would do a lot for me.

thanks in advance

Faheem Rao

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 12:06:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US