Skip to Main Content
Forums

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!

QUERY XML Data from Oracle Database

Oracle ManiacNov 8 2017 — edited Nov 13 2017

Hi Team

I have a requirement wherein i need to pull out few information from an xml file loacated on a  remote Machine. I preferred to load the XML file

into Oracle Table (xmltype) column and then query the XML file from that table. Though the select from my table is too slow only for 5 rows.

Format of Output Data Display: A typical hierarchy can have upto 5 substances, so we can have

medicinalproduct           Activesubstance1        Activesubstance2         Activesubstance3       Activesubstance4    Activesubstance5

Drug1                                 Substance1             Substance2                 NUll                                NUll                              NUll

Sample Data:

       <drug>

            <drugcharacterization>1</drugcharacterization> ----------------------------------**

            <medicinalproduct>Drug1</medicinalproduct> ---------------------------------**

            <obtaindrugcountry></obtaindrugcountry>

            <drugbatchnumb>123</drugbatchnumb>

            <drugauthorizationnumb>123</drugauthorizationnumb>

            <drugauthorizationcountry></drugauthorizationcountry>

            <drugauthorizationholder>Spare MAH</drugauthorizationholder>

            <drugstructuredosagenumb></drugstructuredosagenumb>

            <drugstructuredosageunit></drugstructuredosageunit>

            <drugseparatedosagenumb></drugseparatedosagenumb>

            <drugintervaldosageunitnumb></drugintervaldosageunitnumb>

            <drugintervaldosagedefinition></drugintervaldosagedefinition>

            <drugdosagetext></drugdosagetext>

            <drugdosageform></drugdosageform>

            <actiondrug></actiondrug>

            <drugrecurreadministration></drugrecurreadministration>

            <drugadditional></drugadditional>

            <activesubstance>

               <activesubstancename>Substance1</activesubstancename>  ---------------------------------**

            </activesubstance>

           <activesubstance>

               <activesubstancename>Substance2</activesubstancename>  ---------------------------------**

            </activesubstance>

            <drugreactionrelatedness>

               <drugreactionassesmeddraversion>18.1</drugreactionassesmeddraversion>

               <drugreactionasses>10007515</drugreactionasses>

               <drugassessmentsource>2</drugassessmentsource>

               <drugassessmentmethod>EVCTM</drugassessmentmethod>

               <drugresult>1</drugresult>

            </drugreactionrelatedness>

         </drug>

       <drug>

            <drugcharacterization>2</drugcharacterization>

            <medicinalproduct>Drug2</medicinalproduct>

            <obtaindrugcountry></obtaindrugcountry>

            <drugbatchnumb>123</drugbatchnumb>

            <drugauthorizationnumb>123</drugauthorizationnumb>

            <drugauthorizationcountry></drugauthorizationcountry>

            <drugauthorizationholder>Spare MAH</drugauthorizationholder>

            <drugstructuredosagenumb></drugstructuredosagenumb>

            <drugstructuredosageunit></drugstructuredosageunit>

            <drugseparatedosagenumb></drugseparatedosagenumb>

            <drugintervaldosageunitnumb></drugintervaldosageunitnumb>

            <drugintervaldosagedefinition></drugintervaldosagedefinition>

            <drugdosagetext></drugdosagetext>

            <drugdosageform></drugdosageform>

            <actiondrug></actiondrug>

            <drugrecurreadministration></drugrecurreadministration>

            <drugadditional></drugadditional>

            <activesubstance>

               <activesubstancename>Substance3</activesubstancename>

            </activesubstance>

<activesubstance>

               <activesubstancename>Substance4/activesubstancename>

            </activesubstance>

            <drugreactionrelatedness>

               <drugreactionassesmeddraversion>18.1</drugreactionassesmeddraversion>

               <drugreactionasses>10007515</drugreactionasses>

               <drugassessmentsource>2</drugassessmentsource>

               <drugassessmentmethod>EVCTM</drugassessmentmethod>

               <drugresult>1</drugresult>

            </drugreactionrelatedness>

         </drug>
This post has been answered by Paulzip on Nov 8 2017
Jump to Answer

Comments

Srini Chavali-Oracle

Win Home versions are not certified for Oracle database installs - Oracle Database Preinstallation Tasks

so expect such issues. Is there a reason you cannot use a supported OS version ?

After powering up the laptop, is the database up and running ? You will have to start up the database and listener before you can access the EM Express page - Getting Started with Database Administration

HTH
Srini

user6880652

Hi Srini,

I have also installed Weblogic 12C, and the Weblogic em is working fine as expected. Not sure why the issue comes with Oracle EM only

Possibly because you are using an unsupported version of the OS

Srini

TSharma-0racle 
user6880652 wrote:




I installed 12C Enterprise on my laptop that has Windows 7 Home .The installation process went fine and I was able to connect to http://localhost:5500/em (even used). But, once I powered down my laptop and brought it back up the next day, I couldn't connect ('the page cannot be displayed'). So, I uninstalled oracle and then tried the process again. I could initially connect to 5500/em but after rebooting or powering down the machine, I could not find http://localhost:5500/em.




Can anyone direct me to some specific documentation with this or has anyone conclusively solved this problem to the end????? Thanks for any help.

Shouldn't you be in connecting to HTTPS instead of HTTP(http://localhost:5500/em) OR it is just a typo?

What if you try

https://localhost:5500/em

1 person found this helpful
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 11 2017
Added on Nov 8 2017
10 comments
538 views