Skip to Main Content

SQL Developer Web

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Loading XML data in OAD with Database Actions

Earl LewisMay 24 2023 — edited May 31 2023

I'm dipping toes into the waters of the Oracle Autonomous Database, just so an old guy doesn't get completely left behind all the cool kids. I've provisioned a transaction processing instance and I'm all good getting DA launched. I've used the “Data Load” button to upload an XML file and while there seems to be little control over how the data gets loaded it does load a single row with a CLOB column and all the XML is in that single row CLOB column.

The reason I mention that there seems to be “little control” over the data loading is that although the data in the text file I'm loading is clearly tagged and well formed XML (including namespace, etc) the CLOB seems to have a single XML tag followed by what appears to be JSON data for all of the rows of data.

Is this typical/expected behavior when loading XML data via DA in the Autonomous Database? And if this is the normal mode of loading XML then it seems like it might be reasonable to remove the outer XML wrapping tags from the CLOB and I'll (maybe?) just be left with JSON data? help…

Oh, one more thing. It doesn't look like XMLTYPE is a column type that's available for defining/modifying columns via the GUI with DA. So either I'm doing something that's making it not appear in the column type dropdown list or it's just not there. Would it help my cause at all to create the table via DDL script and then load data into the predefined table?

Comments

Artan Hajdari Feb 11 2025

Can someone help me in this case please

1 - 1

Post Details

Added on May 24 2023
0 comments
402 views