Troubleshooting
Problem
You are running a report to show FULL SQL, but it does not bring the values. Instead it shows the character "?" in the place of values. For example: INSERT INTO TAB1 VALUES (?,?,?,?)
Cause
When using JDBC, in order to properly log Oracle bind variable traffic, you must enable the Inspection Engine parameter Log Records Affected.
Resolving The Problem
Log into the GUI. go to Administration Console > Inspection Engines and enable the following parameter:
Log Records Affected
[{"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.0;8.2;8.1;8.0.1;8.0","Edition":"All Editions","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21664261