SQL tracing is available via the -t 2 or -t 0x2 command line option. The following SQL messages may appear in the log file:
Message
Description
SQL=sqltext
Indicates general SQL tracing where sqltext is the actual SQL command sent to the relational database.
SQL[number]=sqltext
Indicates SQL tracing that involves host variables in the DATABridge Client for Oracle when the configuration parameter aux_stmts has a nonzero value.
Number is the cursor number, and sqltext is the actual SQL command sent to the relational database.
SQL_DATA[number]= ...|...|...
This message, which is limited to the DATABridge Client for Oracle, shows the data being passed to the OCI interface when executing updates involving previously parsed SQL statements that use host variables. Number is the cursor number.