Changes the message text for an existing alert.
SET_ALERT_PROPERTY
(alert_id ALERT,
property NUMBER,
message VARCHAR2);
SET_ALERT_PROPERTY
(alert_nameVARCHAR2,
property NUMBER,
message VARCHAR2);
Built-in Type unrestricted procedure
Enter Query Mode yes
If the message text exceeds 200 characters, it will be truncated.
/*
** Built-in: SET_ALERT_PROPERTY
** Example: Places the error message into a user-defined alert
** named 'My_Error_Alert' and displays the alert.
** Trigger: On-Error
*/
DECLARE
err_txt VARCHAR2(80) := Error_Text;
al_id ALERT;
al_button Number;
BEGIN
al_id := FIND_ALERT('My_Error_Alert');
SET_ALERT_PROPERTY(al_id, alert_message_text, err_txt );
al_button := SHOW_ALERT( al_id );
END;