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.

ORA-01403 No Data Found but sql query returns results

Navneet KaurFeb 14 2025 — edited Feb 14 2025

Hi Everyone

We recently upgraded application from Apex version 5 to apex24.1.7 .

There is a report that shows the error while the others are fine -

report error: ORA-01403: no data found

The query is returned in SQL_DEBUG when the report is run. When the query is run in SQL Commands in APEX, I can retrieve the results. Can you suggest why the results are not displayed when the report is run in apex application, but running the same query in sql_debug brings the results. Here is a snapshot from View Debug in Apex -

Comments

BluShadow Mar 18 2024

Oracle support documents are available to paying customers through the support portal: support.oracle.com

If you are not a paying customer then I'm afraid you won't have access to the document, and it is a breach of any customer's agreement with Oracle to supply such support documents to others.

1 - 1

Post Details

Added on Feb 14 2025
5 comments
62 views