BorlandTalk.com

Jerry Greene · Guest

Often users of my application (written in Delphi 7) get error message "SQL Server Error: ORA-00000: normal, successful completion.", and transaction rolls back.

It happens during execution of the transaction for Oracle 9i database using dbExpress.

Here is the code:

if not SQLConnection1.InTransaction then begin
td.TransactionID := 1;
td.IsolationLevel := xilREADCOMMITTED;
SQLConnection1.StartTransaction(td);

try
// … chores for SQLQuery1
SQLQuery1.ExecSQL;

// … chores for SimpleDataSet1
SimpleDataSet1. ApplyUpdates(-1);

SQLConnection1.Commit(td);
MessageBox(0, 'Success!', PChar(Application.Title), MB_OK);
except
on E: Exception do begin
SQLConnection1.Rollback(td);
MessageBox(0, PChar(E.Message), PChar(Application.Title), MB_OK);
end;
end;
end; { if not SQLConnection1.InTransaction }

Thank you for any suggestions.

Dmitry Arefiev · Guest

Hello

1) What is your exact Oracle client version number ?
2) Which line of your code raises an exception ?
3) Could you provide dbExpress trace output ?

Regards,
Dmitry

--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access engine
ThinDAC - multitier data access engine

Jerry Greene · Guest

1) 9.2.0.1.0
2) I have never had this error, but the clients report that they often get this error. Because all errors are captured and marked, I see that the error is generated during execution of the "SQLConnection1.Commit(td);" statement.

The weird thing is that it says "SQL Server Error", but the Oracle database connection is used.

Thank you.
Jerry

"Dmitry Arefiev" <darefiev@da-soft.com> wrote:

Martijn Tonies · Guest

Dmitry Arefiev · Guest

Jerry Greene · Guest

Thank you.

"Dmitry Arefiev" <darefiev@da-soft.com> wrote: