How to Display Message in Oracle Forms?

How to Display Message in Oracle Forms?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

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:

  • Show_Alert Message Example in Oracle Forms
  • Display modal window message in Oracle Forms

This Post Has 2 Comments

  1. abma August 13, 2020

    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 August 14, 2020

      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.