Test Data Manager

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Hi, has anyone used the portal with an Oracle database that has tables with columns defined as objects? Is this supported?

  • 1.  Hi, has anyone used the portal with an Oracle database that has tables with columns defined as objects? Is this supported?

    Posted May 09, 2019 01:44 PM

    Hi, has anyone used the portal with an Oracle database that has tables with columns defined as objects?

     

    CREATE OR REPLACE TYPE SCHEMA.object_name AS OBJECT (

     n1 NUMBER(11),

     n2 number(7),

     n3 number(05)

    )

    ;

    CREATE TABLE SCRAMBLE.Z_TABLE_TEST_CONTACT

    (

     n4 NUMBER(11),

     n5 NUMBER(7),

     n6 NUMBER(5),

     o1 SCHEMA.object_name ,

     d1 DATE

    )

    The data model correctly reports the table/column type as type SCHEMA.object_name. But the PII scan does not seem to drill down the object to apply the classifier rules to the colmns of the object.

     

    Is this supported?

     

    Thank you