Skip to Main Content
Feature Request FR-3154
Product Area Application Builder
Status DELIVERED

1 Voters

Add error handlers for bad SQL in a LOV control that validates as well formed, but returns too much or bad data

apolinario.vivit Public · May 19 2023

Idea Summary
Add error handlers for bad SQL in a LOV control that validates as well formed, but returns too much or bad data or causes any number of SQL errors.  

Use Case
Some LOV controls may have well formed SQL, but due to the return set cause an internal error when loading the page in page designer, and an error when the page is loaded in the browser. 

Preferred Solution (Optional)
The errors from the server when the SQL is being validated or something be set to return only a limited number of records. Or capture the error and show the SQL as invalid.  While still showing the Page Designer without an error so that the offending code can be fixed. 

This has been delivered in Oracle APEX 23.1 as part of bug 35045970!

Comments

Comments

  • jayson hanes Admin OP 3.1 years ago

    Has this issue been tested on APEX.oracle.com or your own 23.1 instance? - we think it is representative of a bug that was fixed in 23.1

  • apolinario.vivit OP 3.1 years ago

    Sounds good, I will try it on APEX.oracle.com to see if it has been fixed. I'm glad that this has been figured out for 23.1 because I hadn't seen anything on this in the knowledge base.