0 Replies Latest reply on Sep 12, 2019 4:36 AM by Hanane Elkraiti

    Bind variable in dynamic data masking 9.8.3 in oracle

    Hanane Elkraiti New Member

      hello,

       

      I'm using ddm 9.8.3 to mask data displayed in oracle forms application. I have an interface of searching and i set a rule for masking data. I had 2 type of result :

       

      case 1 : This interface don't display the data (apparently he mask the data) and in the same time generate the log bellow :

       

      09/12 17:02:39,267 [DDM for Oracle] INFO  -

      unable to parse bind variables, fireClientDataEvent with Statement Request

      09/12 17:02:39,298 [DDM for Oracle] INFO  - Replace Using rule1

      Original Statement:

      SELECT * FROM CLIENT WHERE NO_CLIENT = :1

      Replaced by:

      SELECT * FROM ((select * from "CLIENT" where NO_CLIENT not in (12,23,45) "CLIENT"

      WHERE NO_CLIENT = :1

      Done by ClientInfo: :[User= X, Host=X, application=X] - SessionID=X - X - Instance 1

       

      09/12 17:02:39,299 [DDM for Oracle-] WARN  - DNRProtocolAdapter.clientData: Bind Variable NULL value cannot be set or replaced

      09/12 17:02:39,299 [DDM for Oracle-3] WARN  - DNRProtocolAdapter.clientData: Bind Variable NULL value cannot be set or replaced

      09/12 17:02:39,299 [DDM for Oracle-3] WARN  - DNRProtocolAdapter.clientData: Bind Variable NULL value cannot be set or replaced

       

      Case 2 : This interface display the data and he didn't applied the rule. He generate the log bellow :

       

      09/12 17:02:39,260 [DDM for Oracle] WARN  -

      failed to process data in state:

      com.activebase.protocols.db.oracle, forwarding data

      com.activebase.protocols.db.oracle: OracleTypeInfo: getValueAsBytes: Unsupported datatype 96

                      at com.activebase.protocols.db.oracle.rc.a(rc.java:200)

                      at com.activebase.protocols.db.oracle.ub.a(ub.java:388)

                      at com.activebase.protocols.db.oracle.kb.a(kb.java:239)

                      at com.activebase.protocols.db.oracle.kb.a(kb.java:112)

                      at com.activebase.protocols.db.oracle.OracleProtocol.clientData(OracleProtocol.java:479)

                      at com.activebase.router.AbstractProtocolAdapter.clientData(AbstractProtocolAdapter.java:80)

                      at com.activebase.router.a.processData(a.java:249)

                      at com.activebase.b.a.d.run(d.java:647)

                      at java.lang.Thread.run(Thread.java:748)

       

      Any explanations for data ???

      It' s urgent.

       

      Thank you.