Error tracing

[issanov]

Hi

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
Dmitri

[tamilselvan]

Set SQL_TRACE = TRUE in INIT.ORA file and examine the trace file.