ApplyUpdates does not work?
Posted: Mon 30 Aug 2010 10:33
We have a problem with the actual ODAC Version. In our Service Application the Data to Oracle is only written or viewable in Oracle SQL Developer wen we stop the Service (OraSession close). In a previous Version of our Service with an older Version of ODAC the Data is written and viewable directly. We testet the same with SDAC and in SDAC the ApplyUpdates Statement works correctly.
By Example:
Connection Parameters:
By Example:
Code: Select all
OraSession.ExecSQL('...', []);
OraSession.ApplyUpdates; //<-- Does not workCode: Select all
OraSession := TORASession.Create(nil);
with OraSession do
begin
Options.ConvertEOL := False;
Options.DateLanguage := 'German';
Options.DateFormat := 'DD.MM.YYYY HH24:MI:SS';
Options.Charset := FCharSet;
Server := FDataBase;
Username := FUsername;
Password := FPassword;
AutoCommit := True;
ThreadSafety := True;
Connected := True;
end;