Hi,
I am using Apex 5.0 my requirement is that when i insert a record into a table (On Submit - After computations and Validations) i required to pop up a message 'Record Inserted'
i tried in below manner but message is not pop up.
I don't want to pop up message from 'Process Success Message'. the moment record got insert into table message should pop up.
Begin
apex_application.g_print_success_message := 'Record Inserted.';
INSERT INTO Emp (EMPNO, ENAME, JOB, SAL, COMM) VALUES(:P4_EMPNO, :P4_ENAME, :P4_JOB, :P4_SAL, :P4_COMM);
HTP.p ('<script type="text/javascript">');
HTP.p ( 'alert(''Record Inserted = '
|| '.\n'
|| 'Job Processed!'');'
);
HTP.p ('</script>');
COMMIT;
END;
Neither 'apex_application.g_print_success_message' or HTP.p is pop up the message.
Can any body help me on this.
Thanks in advance
Ravi