Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need help in extracting xml data stored in a CLOB column and use it in BI Publisher report

Kavishkar111111Sep 2 2014 — edited Sep 3 2014

All,

Need help in extracting xml data stored in a CLOB column and use it in BI Publisher report. Below is the sample xml file stored in database clob column.

[code]

<?xml version="1.0"?>

-<options>-<option id="material">

<description>Material</description>

</option>

-<option id="material_special">

<description>Special Material</description>

-<option id="seat_material">

<description>Seat Material</description>

<value>Stellite 6</value>

</option>

-<option id="seat_material_special">

<description>Special Seat Material</description>

</option>

[code/]

Requirement is to get the output like below in PDF report output.

Material - A105/A106 Gr.B

Material_Special -

Seat_Materila - Stelite 6

Please Help.

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2014

Added on Sep 2 2014

#performance-availability, #xml-db

1 comment

1,195 views