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

SHOW_ALERT Built-in

Description

Displays the given alert, and returns a numeric value when the operator selects one of three alert buttons.

Syntax

SHOW_ALERT
(alert_id Alert);

SHOW_ALERT
(alert_name VARCHAR2);

Built-in Type unrestricted function

Returns A numeric constant corresponding to the button the operator selected from the alert. Button mappings are specified in the alert design.

If the operator selects...

Oracle Forms returns

Button 1

ALERT_BUTTON1

Button 2

ALERT_BUTTON2

Button 3

ALERT_BUTTON3

Enter Query Mode yes

Parameters

alert_id 
 
The unique ID that Oracle Forms assigns the alert when the alert is created. Use the FIND_ALERT Built-in to return the ID to an appropriately typed variable. The data type of the ID is Alert.
 
alert_name 
 
The name you gave the alert when you defined it. The data type of the name is VARCHAR2.

SHOW_ALERT Example

/*

** Built-in: SHOW_ALERT
** Example: See FIND_ALERT and SET_ALERT_PROPERTY
*/