show XML structured data in IR, APEX and XSQL
Hello all,
Situation:
I have a table containing data processing log information like PK, old key, new key,
processing result status etc. for each record.
One colum is a CLOB that contains a composed and valid XML-Data-Struktur.
What I want to have is a IR with all colums except the CLOB,
because this content should only be shown only (in a separete browser window as a XLM struktur) when clicking a linked column in the IR (PK)
I found this seems to be problematic with APEX at this time.
In older times (ca. 8 years ago) I have done a similar stuff with XSQL. ( but only very weak memorization...)
My Question(s):
1. Is it possible to present XML structured data in APEX as described above with standard functionalities.
2. If not, has anyone experience in putting together APEX and XSQL functionalities to make it possible to reach my goal.
Any hint is welcome to me.
Thank you in advance.
Andre