I have a database table. This table has an attribute "TEKST" which contains the XML as a CLOB. My questions is, how can I, with FME, extract the XML from the CLOB so that I can process it like any other XML file?
Many thanks in advance! :)
Question
How can I extract XML stored in a CLOB?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+23- Safer
Hello @aussiepaul , have you tried using the XMLFragmenter? It is typically used to parse data into XML fragments, but it may work in this case. The XMLFragmenter behaves very similar to the XML reader, and we have a great XML tutorial series that shows you how to read, process and write XML with FME!