Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Form - Automatic Row Processing DML - Custom Success message

jozzhJun 14 2024 — edited Jun 14 2024

I find it strange to ask this basic question in 2024, but I'm looking for Best Practices here.

How are you customizing the default Process Success Message?

"Row created / Row updated / Row deleted"

I just want to replace the default texts with

“New Task added” / “Task changes saved” / “Task deleted”

Of course I want to change it for 1 specific page only and NOT globally for the whole app. (no need to overwrite the built-in substition strings)

Possible Solutions:

A

https://forums.oracle.com/ords/apexds/post/success-message-customization-for-form-dml-and-interactive-6524

Success Message:

Excellent - &REQUEST.D &P3_ENAME. / &P3_EMPNO.

Its an ok solution, but it lacks flexibility to show more individual text. (like above)

B

https://forums.oracle.com/ords/apexds/post/how-to-display-seperate-process-success-message-for-insert-9529

One way is create hidden item to that page and computation value according page submit request.
e.g. if request is update then set item value to Record has been updated.
Then place that item to Automatic Row Processing (DML) success message like &Px_YOUR_ITEM.

This would achieve the flexibilty I am looking for, but I do not like the overhead of adding a Page Item for it and also adding a process to actually assign a text to the page item which depends on the submit request.

C

APEX Instant Tip 32 Better Success Messages

This is targeting processes with PL/SQL code executing a DB package. Good tip, but I'm just looking for something simple for the Automatic Row Processing. => Low-code

What would be your best practice?

Comments
Post Details
Added on Jun 14 2024
2 comments
467 views