Loading XML data into Oracle Database

[Anonymous]

Hi All, I have an XML file which contains more child level and members. Each child level having multiple members(Sub Levels). while loading the data it is loading the first member only not all members. I have attached source and XML component screen shot. kindly advise how to process it. Regards, Avinash

[Anonymous · Accepted solution]

Hi,

You have to put your loop element on the members element 😃

Good luck !

[Anonymous]

Not Working, I want to load the role name. which member belongs to what role.

Any advice.

Regards,

Avinash

[Anonymous]

I think, with this solution and your xml schema, the role name must be loaded, can you send a screenshot of your mapping ? 

This mapping should gave you :

| app-role-name | app-role-display-name | member-name 

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Ngoash_N

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | ntshan_n

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Bontsi_H

| BI_CFO_Procurement_Consumer_All | BI CFO Procurement Consumer All Role | Hoffma_A

...

It is not what you want ??

[Anonymous]

Hi Sgv,

Thanks, working on adding members into the loop.

Regards,

Avinash