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

GET_MESSAGE Built-in

Description

Returns the current message, regardless of type.

Syntax

FUNCTION GET_MESSAGE;

Built-in Type unrestricted function

Returns VARCHAR2

Enter Query Mode yes

Parameters

none

GET_MESSAGE Restrictions

GET_MESSAGE is only instantiated when a message is directed to the display device, either by Oracle Forms or by a call to the MESSAGE Built-in. If you redirect messages using the On-Message trigger, a call to GET_MESSAGE does not return a value. Refer to the On-Message trigger for more information.

GET_MESSAGE Examples

/*

** Built-in: GET_MESSAGE
** Example: Capture the contents of the Message Line in a
** local variable
*/
DECLARE
string_var VARCHAR2(200);
BEGIN
string_var := Get_Message;
END;