SQL & PL/SQL

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!

Extract a specific value from a CLOB field and process that value in Oracle.

Shiva509Dec 31 2019 — edited Jan 7 2020

Below is the piece of clob data.

<?xml version="1.0" encoding="windows-1252"?>

<XMI.header>

<XMI.documentation>

<XMI.exporter>Enterprise Architect</XMI.exporter>

<XMI.exporterVersion>2.5</XMI.exporterVersion>

</XMI.documentation>

</XMI.header>

<XMI.content>

<UML:Model name="EA Model" xmi.id="01912248_FDE35517">

<UML:Namespace.ownedElement>

<UML:Class name="EARootClass" xmi.id="11111111_A7F4_CB0AA00" isRoot="true" isLeaf="false" isAbstract="false"/>

</UML:Namespace.ownedElement>

</UML:Model>

</XMI.content>

</XMI>

Need to extract attribute name from UML Class i.e "EARootClass" and process these value using a another table(Assume that there is a table that contains abbreviation of the words).

My final output would be like

<?xml version="1.0" encoding="windows-1252"?>

<XMI.header>

<XMI.documentation>

<XMI.exporter>Enterprise Architect</XMI.exporter>

<XMI.exporterVersion>2.5</XMI.exporterVersion>

</XMI.documentation>

</XMI.header>

<XMI.content>

<UML:Model name="EA Model" xmi.id="01912248_FDE35517">

<UML:Namespace.ownedElement>

<UML:Class name="EA_RT_CLS" xmi.id="11111111_A7F4_CB0AA00" isRoot="true" isLeaf="false" isAbstract="false"/>

</UML:Namespace.ownedElement>

</UML:Model>

</XMI.content>

</XMI>

Thanks in advance,

Shiva

This post has been answered by Paulzip on Jan 5 2020

Jump to Answer

Phil Richens-Oracle

Hi,

I'm not immediately sure what the problem is.

Would you add the detailed information from the Logging Page (seen in your screenshot) please? To do this, double click on each cell in the Source and Message columns. This will open the Cell Value dialog containing the complete value from the cell. Just copy and paste those and put them in your reply here please.

Also would you get me the Java version you are using. To find this out, first click "Help -> About" in the SQLDev menu bar to open the "About" dialog. Then select the "Version" tab. There, you should see the version string for "Java Platform". Again, please copy this string into your reply.

Thanks.

Philip Richens

SQLDev Development Team.

user11041010

Hi Philip

Here is the info you requested:

Source

oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$1

Message

null at oracle.dbtools.raptor.oviewer.xmleditor.XMLBasedEditor.updateContent(XMLBasedEditor.java:523)

Source

oracle.dbtools.raptor.oviewer.base.AsynchronousViewerEditor

Message

javafx/scene/layout/GridPane at java.lang.ClassLoader.defineClass1(Native Method)

Java version:

1.8.0_40

Thanks

thatJeffSmith-Oracle

Could you share what version of the database you're connected to as well?

Phil Richens-Oracle

Thank you.

Could you also specify which O/S version you are running in please?

Philip.

Marwim

Same problem

maybe the well known bug about XML and new JDBC driver agains an older db-version (11.2.0.2)?

Edit:

Regards

Marcus

user11041010

The PC OS version is windows 7 enterprise edition, 64 bit.

I have encountered this issue on the following Oracle versions:

10.2.0.5.0 (running on Solaris 10)

11.2.0.4.0 exadata, RAC, running on Linux

The version of Oracle client I am using is 11.2.0.2.0.

thatJeffSmith-Oracle

The closest we can figure, without having your machine in front of us to live debug, is that there's something off with your JDK.

Are you running the EA2 that included the JDK, 1.8u40 or did you install Java 8 on your own?

It's possible one of the jar's in that home are corrupted or incompatible for some reason.

user11041010

I was running EA2 with the JDK included. I have just deleted that install, downloaded EA2 again and unzipped it, and I'm still getting the same error.

thatJeffSmith-Oracle

can you install java 8 and use that instead of the embedded jdk?

user11041010

The organisation where I work has security policies on my PCs that prevent me from running .exe installers. Is there a .zip download for java 8 ?

Marwim

Hello Jeff,

I just downloaded sqldeveloper-4.1.0.18.37-no-jre.zip and started it with JDK1.8.0_31 on WIN7 64bit. It works. I use the same connection against 11.2.0.2 as with sqldeveloper-4.1.0.18.37-x64.zip where I get only the waiting message.

Marcus.

thatJeffSmith-Oracle

Sounds like the problem is with our embedded JDK then.

1304146

I just changed the product.conf from the built-in JDK 1.8 to an externally downloaded one - it works perfectly now after having the same issue as before. Win7 64 bit

thatJeffSmith-Oracle

yeah, we were shipping the server JRE - which doesn't include JAVA FX, which is a client type of thing. What we ship embedded in the final 4.1 release will have the Java FX required jars and this will work as expected.

1 - 14

Added on Dec 31 2019

#plsql, #xml

10 comments

2,168 views

SQL & PL/SQL

Extract a specific value from a CLOB field and process that value in Oracle.

Comments

Post Details