Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Logging SQL syntax errors?
A developer asked me if there was a way to turn on logging for Oracle so that we can see what SQL was sent to the server (not what is executing)? It is basically to track what SQL caused a syntax error. I told him I don't think so. It is up to the developer to know what SQL he is sending along. (It was actually toplink generating SQL that then caused a syntax error, and I told him he needed to get toplink to log that.)
Anyways, can we do this somehow. It seems that we would be asking Oracle to write way more Ascii text than it would want to. I'm thinking that we could turn this on at the jdbc level though.
-- Galen Boyer Database Architect Primix Solutions, www.primix.comReceived on Thu Jul 20 2000 - 00:00:00 CDT