Trace events for debugging query
527132Aug 8 2007 — edited Aug 10 2007hi,
our database is running on Oracle 9i / Red hat linux release 3 and we have an application developed in Forms 4.5 accessing this database from the front end
I am getting an application related error for which the code is not with us , now I need to set up an event and trace this session to obtain the failing sql.
please suggest which event should be set and at what level , I need to trap the failing sql with the bind varaibles
I have tried oradebug with
SQL> oradebug event 10053 trace name context forever,level 4;
Statement processed.
it worked fine but i could not trap the bind variables in it
please help as early as possible.
Altaf.