Skip to Main Content

APEX

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Fix for ORA-01403 No Data Found in Oracle APEX

jaramillDec 29 2024 — edited Dec 29 2024

This is an error I encountered recently specifically when you run into the error pointing to the "process for Initializing form", and for the life of mean I couldn't figure why it all of a sudden came up as the error did not a appear on other similar pages with similar logic. It turns out when I went to “DELETE” a record from a FORM, it needed to process the delete via a “Processing” process but also a BRANCH to go to another page after all was said and done.

IF it did not have this branch it would revert back to the same page that I did the delete and try to re-query the record I just deleted hence the “NO DATA FOUND” error!

Lesson learned.

Running on Oracle Apex 21.2.3 on Oracle Database 19

Comments

Processing

Post Details

Added on Dec 29 2024
2 comments
335 views