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

MESSAGE Built-in

Description

Displays specified text on the message line.

Syntax

PROCEDURE MESSAGE
(message_string VARCHAR2,
user_response
NUMBER);

Built-in Type unrestricted procedure

Enter Query Mode yes

Parameters

message_string 
 
Specify a character string enclosed in single quotes or a variable of VARCHAR2 data type.
 
user_response 
 
Specifies one of the following constants:

ACKNOWLEDGE Specifies that Oracle Forms is to display a modal alert that the operator must dismiss explicitly, whenever two consecutive messages are issued. ACKNOWLEDGE forces the first message to be acknowledged before the second message can be displayed. This is the default.

NO_ACKNOWLEDGE Specifies that, when two consecutive messages are issued, the operator is not expected to respond to the first message displayed before Oracle Forms displays a second message. Using NO_ACKNOWLEDGE creates a risk that the operator may not see the first message, because the second message immediately overwrites it without prompting the operator for acknowledgement.

MESSAGE Restrictions

The message_string can be up to 200 characters long. Note, however, that several factors affect the maximum number of characters that can be displayed, including the current font and the limitations of the runtime window manager.

MESSAGE Examples

/*

** Built-in: MESSAGE
** Example: Display several messages to the command line
** throughout the progress of a particular
** subprogram. By using the NO_ACKNOWLEDGE parameter,
** we can avoid the operator's having to
** acknowledge each message explicitly.
*/
PROCEDURE Do_Large_Series_Of_Updates IS
BEGIN
Message('Working... (0%)', NO_ACKNOWLEDGE);
/*
** Long-running update statement goes here
*/

SYNCHRONIZE;
Message('Working... (30%)', NO_ACKNOWLEDGE);
/*
** Another long-running update statement goes here
*/
Message('Working... (80%)', NO_ACKNOWLEDGE);
/*
** Last long-running statement here
*/
Message('Done...', NO_ACKNOWLEDGE);
END;