#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0

    Unhappy Need help to import XML date to Oracle


    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. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2012
    Posts
    2
    Rep Power
    0

    Please help me


    some body pls help me do the above

    Thanks in advance.

    Regards
    Hisham.A

IMN logo majestic logo threadwatch logo seochat tools logo