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!

ORA-01403: no data found - RESTful Services (APEX>SQL Workshop)

Hi Experts,
We have been using Oracle APEX and ORDS for enabling REST Services.
Oracle APEX Version : Application Express 19.2.0.00.18
ORDS Version : 19.2.0.r1991647
I created a module with POST handler. It got created and now i am trying to update it, it keeps erroring as ORA-01403: no data found. I realize the PL/SQL code contains an program error.
I am unable to update the code as the system says 'No Data Found'.
Is there a way to update the code to the right one and have the API.
It is now not even allowing me to create a new one. All handler creation is erroring with No data Found error.
Kindly let me know if there are ways to fix this issue.
image.png
Regards,
Bala

Comments
Post Details
Added on Jan 17 2022
1 comment
679 views