I have an application working with Oracle database,
and I don't have access to source code.
Some transactions fail but this app doesn't generate
any logs. I use distributed transactions.

How can I trace errors occuring while executing
SQL statements, session initialization, etc?
All I need is to get ORA error number and SQL code
that caused the error.

Thank you