In Oracle Forms, there are two ways to display a message. One is using MESSAGE() built-in and the second one is by using ALERTS in Oracle Forms. In this tutorial, you will learn how to display a message in Oracle Forms using MESSAGE and ALERTS.

Display Message in Oracle Forms Examples

1. Using Message command.

Syntax

Message(message_text);

Example

The MESSAGE built-in is used to display a message at status bar in Oracle Forms. The following example will show the message at the Status bar in Oracle Forms.

Begin
    Message('Hello World!');
End;

2. Using Show_Alert command for Window messages.

Syntax

N := Show_Alert(alert_name);

Example

ALERTS are used to display a message as a modal window in Oracle Forms. The following example will show the message you created for alert infoalert.

declare
n number;
begin
n := show_alert('infoalert');
end;

See also:

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.

This Post Has 2 Comments

  1. abma

    Since Oracle Forms is a little bit old and definitely out of date due to the recent technologies. Can you tell me if there is big companies whom are still using this technology of Oracle.
    If you do, please name them if you don't mind.

    Best regards.

    1. Vinish Kapoor

      Yes Oracle Forms is little bit old but still there are many large size companies using it and some of them even are not thinking to migrate their applications to other latest technologies as soon as Oracle Forms is working and supported by Oracle.

      I have worked on many domains mostly in Asia, and found the biggest brands which are using Oracle Forms in retail, banking, hospitality and medical sectors.

Comments are closed.