Show generated value sequence in form submission success message for Oracle Apex

There are two ways to display a message about the successful completion of a process: first, in the Messages

process properties section , put the desired message in Process Success Message

, second, in the process code, do the following:

begin
  apex_application.g_print_success_message := 'your message here';
end;

      

        
        
        
      

    

apex_application.g_print_success_message

is a variable of the standard APEX package apex_application

. In your case, it's easier to add this line of code to calculate the identification process.

UPD
Example of a standard Get a PC process with message generation:

begin 
    if :P12_ID is null then
        select "MY_SEQ".nextval
          into :P12_ID
          from sys.dual;
    end if;
  apex_application.g_print_success_message := 'new ID is ' || :P12_ID;
end;