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

MESSAGE_TYPE Built-in

Description

Returns a message type for the message that Oracle Forms most recently generated during the current Runform session.

Use MESSAGE_TYPE to test the outcome of a user action (e.g., pressing a key) to determine processing within an On-Message trigger.

Syntax

FUNCTION MESSAGE_TYPE;

Built-in Type unrestricted function

Returns VARCHAR2

MESSAGE_TYPE returns one of three values for the message type:

Enter Query Mode yes

Parameters

none

MESSAGE_TYPE Examples

/*

** Built-in: MESSAGE_CODE,MESSAGE_TEXT,MESSAGE_TYPE
** Example: Reword certain FRM message messages by checking
** the Message_Code in an ON-MESSAGE trigger
** Trigger: On-Message
*/
DECLARE
msgnum NUMBER := MESSAGE_CODE;
msgtxt VARCHAR2(80) := MESSAGE_TEXT;
msgtyp VARCHAR2(3) := MESSAGE_TYPE;
BEGIN
IF msgnum = 40400 THEN
Message('Your changes have been made permanent.');
ELSIF msgnum = 40401 THEN
Message('You have no unsaved changes outstanding.');
ELSE
/*
** Print the Normal Message that would have appeared
**
** FRM-12345: Message Text Goes Here
*/
Message(msgtyp||'-'||TO_CHAR(msgnum)||': '||msgtxt);
END IF;
END;