DML error logging

[a-s-z]

Hello,

is it possible to use the error logging feature of oracle 10g (dbms_errlog) with ODAC when using dynamic generated update sql? Or do I have to construct the update sql statically to use this feature?

An additional property "ErrorTable" or similar for TOraQuery would be nice!

[bork]

ODAC doesn't support error logging feature of Oracle 10g (dbms_errlog). But you can use TOraErrorHandler for catching and logging all Oracle errors.

We will think about support error logging feature and will try to implement it in the future.

[a-s-z]

Hello,

when using TOraErrorHandler, I do not get the row data received the server.
I have added the "log errors" clause to the corresponding insert statement, but so I cannot use Odac's feature of dynamic query generation...

I have generated the insert query in the following way:

Code: Select all

    with TDBAccessUtils.GetDataSetService(AQuery).SQLGenerator do
    begin
      AQuery.SQLInsert.Text := GenerateSQL(stInsert, False, nil);
      if AQuery.SQLInsert.Count > 0 then
      begin
        AQuery.SQLInsert.Append('  LOG ERRORS REJECT LIMIT UNLIMITED');
        AQuery.DMLRefresh := False;
        AQuery.Options.StrictUpdate := True;
      end;
    end;