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

41 Voters

Native Support To Display Error/Success Message from Dynamic Action(Execute PLSQL Code)-OnClick

ashok lokhande Public · Aug 22 2021

Idea Summary
Currently its very hard to display error messages coming from Dynamic action - execute PLSQL process. Specially if we have Execute PLSQL code  on Button Click DA and want to show error to user coming form PLSQL Code.

Use Case
Ex. Inline dialog, opening using Callout. we have few text items in Inline Dialog , want process data entered by user in these items without submitting the page.

Preferred Solution (Optional)
Native DA - Excecute Server side code needs to be modify / or any new option to show messages from process

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

Known Duplicates

Known duplicates

FR-3969
FR-3969 Better error handling in "Execute Server-side Code" dynamic actions

Comments

Comments

  • sven.weller OP 8 months ago

    Imo this is not a duplicate of FR-2573.
    The logic to supply the success message needs to be part of the plsql process, not a separate dynamic action.

    To display error messages we can already use raise_application_error inside the plsql block. But there is no easy way to show a success message.

    It might be a duplicate of : FR-3883

  • vincent morneau Admin OP 8 months ago

    Thanks for pushing back. It's indeed not a duplicate. Back to open and we will reevaluate soon.

  • vincent morneau Admin OP 8 months ago

    This idea was reevaluated today, and it was decided that we will close it again. When FR-2573 is delivered, the workaround will be simple enough by returning data from the PLSQL block, and passing it to the next DA action which is a declarative success/error message.

  • andrea galizzi OP 8 months ago

    Why I have to create an hidden page item and a new DA when the APEX_ERROR PL/SQL APIs could have handled all of that (as in page submission)?

    What if I have multiple errors in one process? I have to create a page item for every possible error? Or should I format them in JSON and split them in JavaScript to show them in the page with the new DA?

    Page validations and processes already manage all this by using declarative option and the APEX_ERROR.ADD_ERROR PL/SQL API.
    If the PL/SQL ajax call followed the same logic, every scenario I can think of would be very easy to handle.

  • patrick wolf Admin OP 8 months ago

    Ok, so the core of this idea is to use apex_error.add_error—potentially calling it multiple times—to associate specific errors with page items, similar to how validations work.

  • michael.poetscher2 OP 5 months ago

    This would be something we are also looking for.

  • ronny.weiss2 OP 3 months ago

    Would be great if this is a feature of APEX, if you need it now, there's a plug-in that does exactly this:

    https://apex.world/ords/r/apex_world/apex-world/plug-in-details?p710_plg_int_name=RW.APEX.SHOW.HIDE.SPINNER