Five Stars

Loading XML data into Oracle Database

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

1 ACCEPTED SOLUTION

Accepted Solutions
Five Stars sgv
Five Stars

Re: Loading XML data into Oracle Database

Hi,

 

You have to put your loop element on the members element =)

 

Good luck !

4 REPLIES
Five Stars sgv
Five Stars

Re: Loading XML data into Oracle Database

Hi,

 

You have to put your loop element on the members element =)

 

Good luck !

Five Stars

Re: Loading XML data into Oracle Database

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

Any advice.

 

Regards,

Avinash

Five Stars sgv
Five Stars

Re: Loading XML data into Oracle Database

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 ??

 

Five Stars

Re: Loading XML data into Oracle Database

Hi Sgv,

 

Thanks, working on adding members into the loop.

 

Regards,

Avinash