Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy XML Import to Oracle database

    Hi

    I am new to XML Development. In our project we need to import XML data to Oracle database.

    Please see the example below

    There is a table "Claim" with two field "ID" and "Claim Name"

    The field "ID" is autoincrement Primary Key which will take the value from the sequence created.

    The value for field "Calim Name" will get from the XML DOC.

    The "ID" of table "Claim" is Foreign key of another table "Activity" because of this we cannot create a trigger for taking the Primary key during insertion of value in "Claim" table.


    I need to know two informations:

    1. How to import the XML values in to the table "Claim"?
    2. How to insert the auto generated Primary Key ID in to " Claim" table and also as Foreign key of "Activity"?

    Please help me to sort out this complex situation.

    Thanks in Advance.

    Regards
    Hisham.A

  • #2
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unhappy Please help me in this topic

    Hi all,

    Its very urgent for me to know the above requirement .
    We are using Oracle 11G. Please help.

    Thanks in Advance

    Regards
    Hisham.A

  • #3
    Moderator
    Join Date
    May 2002
    Location
    Hayward, CA
    Posts
    1,461
    Thanks
    1
    Thanked 23 Times in 21 Posts
    I realize no one's responded yet. That often happens when no one knows the answer. I certainly don't, because I've never worked with Oracle databases.

    MySQL, yes. (I'm aware Oracle now owns MySQL.)
    "The first step to confirming there is a bug in someone else's work is confirming there are no bugs in your own."
    June 30, 2001
    author, Verbosio prototype XML Editor
    author, JavaScript Developer's Dictionary
    https://alexvincent.us/blog

  • #4
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Smile Thanks

    Dear Alex,

    thanks for the reply. I got some help from the below blog.

    http://grow-n-shine.blogspot.com/201...33717048267528

    please refer in some where in forum..it will be helpful for others..

    On the same time can you please share hw to import xml to my sql.

    Regards
    Hisham.A

  • #5
    New to the CF scene
    Join Date
    Jun 2012
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You can export and import this data regardless of the XMLType storage format (structured, unstructured, or binary XML). However, Data Pump exports and imports XML data as text or binary XML data only. The underlying object-relational tables and columns used for structured storage of XMLType are thus not exported. Instead, they are converted to binary form and then exported as self-describing binary XML data. XMLType data stored as CLOB instances (unstructured storage) is exported as text.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •