Overview
This document explains how to give a customized Error Message using minimal PL/SQL code in Oracle APEX.
Technologies and Tools Used
The following technologies has been used to achieve the fancy checkbox in oracle apex.
- Oracle Apex
- PL/SQL
Use Case
Any requirement for customized Error Message , we can use this following steps. By default, the Oracle Apex allows creating a simple Page Process within that we need to write customized Code. But it can be modified to any other symbol.
Steps with Screenshot
Steps to be followed :
Step 1: Create a region and within that create text box name is P6_TEXT_BOX and set type is Text field.
Step 2: Create a Page Process and PL/SQL Open Code,
Step 3: Then, Open ‘Validation Message’ Process Within that Write Below Code For inline error Message and alert box error message.
IF :P6_TEXT_BOX IS NULL THEN
apex_error.add_error (
p_message => ‘Must Have Some Value’,
p_display_location => apex_error.c_inline_with_field_and_notif,
p_page_item_name => ‘P6_TEXT_BOX’);
END IF;
Step 4 (optional): Below Code For Only inline error Message.
IF :P6_TEXT_BOX IS NULL THEN
apex_error.add_error (
p_message => ‘Must Have Some Value’,
p_display_location => apex_error.c_inline_with_field,
p_page_item_name => ‘P6_TEXT_BOX’);
END IF;
Output:
Below screen shot shows Customized Error Message.
