SQL Trace

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.