Re: Tracing TNS connection

Hi,
alter system set events '933 trace name errorstack level 3' Should generate a dump with the statement (I'm not 100% sure for a syntax error).
Regards,
Franck
Le mer. 13 sept. 2017 à 18:15, David Hicken <utahtoad_at_gmail.com> a écrit :

> We have an COTS software that is sending a bogus SQL statement to the
> Oracle RDBMS (11.2.0.4). The error message (ORA-00933: SQL command not
> properly ended) doesn't give us a clue as to what is really wrong because
> it appears to be a data item rather than a syntax error. Because it appears
> to be a literal, it doesn't make any difference to the SQL area.
>
> Is there any way to "sniff" what the SQL is that comes through the TNS? I
> know of tracing, but I'm not sure how or at what level might catch this.
>

--
http://www.freelists.org/webpage/oracle-l