Question & Answer
Question
Why are bind variables missing for Oracle encrypted traffic captured using ATAP?
I have executed the following SQL procedure on an Oracle database where ATAP is activated (i.e. traffic is encrypted)
SQL> variable deptno number SQL> exec :deptno := 10 PL/SQL procedure successfully completed. SQL> select * from app_user.bigdecimal where bignumber = :deptno; no rows selected SQL> exit I expect my reports to show the bind variables correctly but they don't. I performed the same procedure without ATAP activation (i.e. traffic is not encrypted) and I can see bind variables just fine (highlighted in green).
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSMPHH","label":"IBM Security Guardium"},"Component":"ATAP","Platform":[{"code":"PF016","label":"Linux"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Product Synonym
Guardium;DAM;
Was this topic helpful?
Document Information
Modified date:
25 March 2020
UID
ibm16116698