Skip to Main Content
Feature Request FR-1753
Product Area Application Builder
Status ROADMAP

98 Voters

Warn me if I reference a bind variable that does not exist

michael.hichwa APEX Team · Aug 19 2021

Idea Summary
When defining SQL region content for reports and charts APEX developers frequently reference application session state using bind variables, for example …where driverid = :p10_driver_id.  It would be nice to warn the developer that :P10_driver_id does not exist when it does not exist.  

Use Case
APEX knows if the bind variables exist.  They may not exist when writing the query thus its fine to be a warning and not an error.

Preferred Solution (Optional)
in page designer and other places in apex you can validate your query; provide option to validate bind variables.

This is currently on the roadmap for a future release of Oracle APEX.

2 Comments

Comments

  • gabriel.diaz.arias OP 3.6 years ago

    I would extend this as integrating apex advisor warnings on page designer after saving changes. It would be nice having a “Advisor” or “Warnings” tab to solve.

  • jkerr OP 3.6 years ago

    And it would be nice if bind variable names were not case sensitive.