This content has been marked as final. Show 8 replies
Cleopatra wrote:What exception you are getting? is there any PL/SQL code involved?
Is there a way to make the error message from a dynamic action more user-friendly.
I have this dynamic action which sets a value for a certain item based on a condition, but when I get an exception I would like to display
a user friendly message.
Cleopatra wrote:Hi Cleo,
I am getting the following:
"AJAX call returned server error ORA-01403: No data found for Set Value."
How can I make this message more user friendly in the dynamic action?
Yes I set the value using PL/SQL in the dynamic action.
Would you tell the user that An error occurred every time they run through no_data_found ?.
No Data found is not an unexpected error, should you not handle it in your code by adding an exception block??
Even though if you add the above exception block still you may get different ORA-error and it seems that you have not implemented the error_handling function.
exception when no_data_found then return null; end;
So as Tony already suggested create this error handler function and define it in your application definition.
for completeness, the "error handling function" of APEX will not be called for AJAX calls in APEX 4.1. But the good news is that in APEX 4.2 this has been changed and you can now always use "Error Handling Function" to modify any error message raised by APEX or your application.
My Blog: http://www.inside-oracle-apex.com
APEX Plug-Ins: http://apex.oracle.com/plugins
But I am indeed still getting that error, even though I have an exception block present in the pl/sql code.
And like Patrick said that that error Handling functions will not be call from AJAX Calls and in Apex 4.2 it is possible to modify error messages.
Thanks for you time anyway.