Skip to Main Content

DevOps, CI/CD and Automation

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!

Best practices to create an XML file with PLSQL

Ernesto DíazApr 12 2018 — edited Apr 13 2018

Hi All,

I am generating an XML file but I am not sure which is the best option.

Normally I used to create a CLOB variable and after convert with XMLType, but I am not sure if I create using the API dbms_xmlDom is better than it.

Information is coming from several tables, I have a nested for with an explicit cursors...

What do you suggest it?

Thanks in advance,

Ernesto

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2018
Added on Apr 12 2018
1 comment
4,744 views