We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Our Support systems migrated on Saturday, May 21. We'll automatically forward you to the new location for this content.

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

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

Comments

2 comments

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.

Comments

Attached files

Didn't find what you were looking for?