How to show message dynamically in Oracle Forms

Saturday, June 21, 2014

Using form personalization we can show custom message on defined actions.

To show the different message content based on the form data, we can use form personalization.

Create a PL/SQL function

>> Return different message based on predefined rules (conditions)

Function –

xxx_pkg.getmessage(param1 VARCHAR2) return VARCHAR2

BEGIN

If param1 = 1 THEN return ‘Sandeep’ end if;

If param1 =2 THEN return ‘OAL’ END IF;

EXCEPTION

Return ‘Exception in custom program’

END ;

>>> Create a form personalization to display message

= select xxx_pkg.getmessage(Paramaer) from dual

OA - Learning