Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem when migrating Apex REST to ORDS REST

Tu NguyenAug 31 2020 — edited Aug 31 2020

Lately I update my ords version from 3 to 20.

After update, I see that Apex REST no longer supported, Oracle encourages me to migrate it to ORDS Restful services by automatic process.

However, when clicking the Migrate button, this error occured:

Unable to migrate services. unique constraint (ORDS_METADATA.ROLES_UNQ_NAME) violated

Any ideas?

Comments

Solomon Yakobson
Answer
select  to_char(trunc(entry_date,'MM'),'MM YYYY),
        sum(qty) qty
  from  your_table_name
  group by trunc(entry_date,'MM')
  order by trunc(entry_date,'MM')
/

SY.

Marked as Answer by SANPAT · Aug 9 2022
1 - 1

Post Details

Added on Aug 31 2020
7 comments
614 views