Re: STATISTICS=YES does nothing with ifrun60.exe

Abi,
  Is this Abi, or Eric?

  The debugging tools in Oracle tools are not what I was use to in Delphi, so after much hunting around I settled on growing my own. I use a proc that uses text_io to write a file on the user's PC. Admittedly, this won't work if you can't modify the form first, but if you can it will fill the bill. The proc just opens a hardcoded text file, writes what is passed to it (plus the sysdate) and then closes the file. Where I have SQL commands in the form I first call this proc passing the basic SQL and enough of the bind variables to let me know what is happening.

"Eric J. Givler" <ericjgivler_at_earthlink.net> wrote in message news:nTBd8.9191$0C1.777453_at_newsread1.prod.itd.earthlink.net...
> I read in a debugging note that statistics=yes would turn on debugging and
> output information from my session to the dbserver user_dump_Dest. I went
> there and found NOTHING. What's the scoop?
>
> Similarly, I turned on client-side SQLNET tracing via Sqlnet.ora, and when
I
> tried to run trcaasst.exe (under windows nt), it returned a TNS-04280
> Internal Error and did not process the file.
>
> How do I determine what is causing an ORA-01422 that a user is getting in
an
> application without seeing the offending SQL statement EASILY in some
> captured log, other than STEPPING code in the debugger which seems a
little
> ridiculous.
>
> Ideas?
>
>
Received on Mon Feb 25 2002 - 20:27:41 CET