Skip to Main Content
Feature Request FR-5026
Product Area SQL Workshop
Status OPEN

1 Voters

Add PL/SQL Code Validation to the RESTful Services Module Editor

oegidio2 Public · Sep 13 2026

Idea Summary
When developing a RESTful Services Module in Oracle APEX, the PL/SQL editor does not currently provide a way to validate or compile the PL/SQL code before applying the changes.

As a result, it is possible to click "Apply Changes" even when the PL/SQL code contains syntax or compilation errors. The developer may only discover the problem when testing or executing the REST endpoint.

This creates an unnecessary development and troubleshooting cycle, especially when the error message returned during execution does not immediately identify the exact problem in the source code.

Use Case
A developer is creating or modifying a RESTful Services Module and writes PL/SQL code in the handler source.

Before applying the changes, the developer wants to verify that the PL/SQL code is syntactically valid and can be compiled successfully.

Currently, there is no apparent validation action available directly in the editor. The developer must apply the changes and then invoke/test the REST service to discover whether the code contains errors.

When an error occurs, developers may have to use additional workarounds or debugging techniques to identify the actual PL/SQL compilation problem.

Preferred Solution (Optional)
Please consider adding a "Check PL/SQL", "Validate", or similar action to the PL/SQL editor used by RESTful Services Modules.

The validation feature could:

  1. Validate/compile the PL/SQL code without executing the REST endpoint.
  2. Display syntax and compilation errors directly in the editor.
  3. Ideally identify the relevant line and column where the error occurs.
  4. Prevent or clearly warn the developer before applying invalid code.
  5. Provide the same type of immediate feedback developers expect when working with PL/SQL in other Oracle development tools.

Even a simple "Check PL/SQL" button that validates the source code would significantly improve the developer experience and reduce the time spent troubleshooting RESTful Service handlers.

This would make the RESTful Services development experience more consistent with the capabilities developers already expect from Oracle PL/SQL development environments.

This idea is open.