I am using Toad for Oracle 12.8 on two Oracle 11g environments - DEV and UAT. On DEV everything works perfect but on UAT when executing any query (select, update, delete - no matter) I get the following error.
ORA-02002: error while writing to audit trail
ORA-22923: amount of data specified in streaming LOB write is 0
There are two weird things:
- After the error, it still displays the result of the query.
- I tried using SQL developer, same login credentials and that does not give me any error.
Do you maybe have any suggestions what Toad is doing?