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

Follow

Vignesh Menon

• July 09, 2020 13:27

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

0

• 

  Neeraj Jaiswal

  • July 09, 2020 17:22

  I have attached the screenshots here.

  0

  Comment actions Permalink
• 

  Neeraj Jaiswal

  • July 09, 2020 17:23

  attachment

   

  Attached files

  XML-Screenshots.zip

   

  0

  Comment actions Permalink

Please sign in to leave a comment.