A script-enabled browser is required for this page to function properly.

SET_ALERT_PROPERTY Built-in

Description

Changes the message text for an existing alert.

Syntax

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

Parameters

alert_id 
 
Specifies the unique ID (data type ALERT) that Oracle Forms assigns to the alert when it is created. Return the ID to an appropriately typed variable.
 
alert_name 
 
Specifies the VARCHAR2 name of the alert.
 
property 
 
Specifies the specific alert property you are setting:

ALERT_MESSAGE_TEXT Specifies that you are setting the text of the alert message.

TITLE Specifies the title of the alert. Overrides the value specified in Oracle Forms unless the property value is NULL.
 
message 
 
Specifies the message that is to replace the current alert message. Pass the message as a string enclosed in single quotes, as a variable, or in a string/variable construction.

SET_ALERT_PROPERTY Restrictions

If the message text exceeds 200 characters, it will be truncated.

SET_ALERT_PROPERTY Example

/*

** 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;