Assure DQ

 View Only
Back to discussions
Expand all | Collapse all

How to read XML data Column in Oracle DB into a Detail Control

  • 1.  How to read XML data Column in Oracle DB into a Detail Control

    Posted 07-09-2020 06:28

    Dear Team,

     

    We have a database table which contains one XML column. We would like to read certain values within this XML column.

    To test this, for now I have created a database layout pointing to the Insight Oracle database in our dev environment.

    In this layout I have defined the XML column via a Sub-Layout which contains the exact structure of this XML data.

    I tested this layout and it seems to be reading the data as expected.

    However when I read it via a control,It throws an error. I will share the screenshots of the contol run error in seperate email. 

    So please help us by providing the steps in reading this layout data into control.

     

    Regards

    Vignesh



  • 2.  RE: How to read XML data Column in Oracle DB into a Detail Control

    Posted 07-09-2020 10:22

    I have attached the screenshots here.



  • 3.  RE: How to read XML data Column in Oracle DB into a Detail Control

    Posted 07-09-2020 10:23

    attachment

     

    Attached files

    XML-Screenshots.zip