Debugging/tracing embedded sql

Question

Is there a way to trace/log sql from the code (not from the db side, but rather what the code thinks it's doing)?

I am using Pro*C/C++: Release 8.1.7.0.0 for Oracle

Answer 1

"the code thinks it's doing" Code doesn't think. If it did, I wonder if we would have more or fewer problems :)

But you could look into SQLNet trace at the SUPPORT level if you are interested in what statements the client is sending to the server (and responses back) rather than the statements executed by the server (ie omitting SQL executed by a procedure on the server rather than directly issued by the client).