1- I have created an Oracle DB View using the attached DDL; it is working fine i

mohamedb over 8 years ago

1- I have created an Oracle DB View using the attached DDL; it is working fine in the DB and it does not have a primary key.
2- I then created the corresponding CDT using the XSD attached.
3- Now, when I try to add the entity representing this view to the Data Store and click Verify I get the attached error message.

Please, advise on how to solve this problem. My end goal is to use this view to fetch data into tables used on my entity backed record that get its information from another table.

view + xsd + error.zip

Discussion posts and replies are publicly visible

Parents

0 nageswararaoa over 8 years ago

Based on your view data you can make a unique column by concatnating the column values.
I am not sure what data your view returning.But try to make a unique column by concatnationg the columns which are joined in your view.
If it is not possible to make a unique column refer the below link to generate an unique id using sequence
community.oracle.com/.../2190087
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 nageswararaoa over 8 years ago

Based on your view data you can make a unique column by concatnating the column values.
I am not sure what data your view returning.But try to make a unique column by concatnationg the columns which are joined in your view.
If it is not possible to make a unique column refer the below link to generate an unique id using sequence
community.oracle.com/.../2190087
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data