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.