Returns the current message, regardless of type.
FUNCTION GET_MESSAGE;
Built-in Type unrestricted function
Returns VARCHAR2
Enter Query Mode yes
none
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.
/*
** 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;