Example is given below to validate a Text Item in Oracle Forms with specific rules condition which can be define at run time with the use of T-List item and When-Validate-Item trigger. 

Below is the screen shot of this example form which can be download free from Google Drive with the following link: Validate.fmb


The following trigger is written in the When Validate Item trigger:

if :rules = 'Must Not Be Blank' then
if nvl(:wvi,'-_-') = '-_-' then
  bell;
  Message(:rules);
  raise form_trigger_failure;
end if;
elsif :rules = 'Can Be Blank But Can Not Have Numeric Value' then
if length(replace(translate(:wvi, '0123456789', '          '), ' ')) < length(:wvi) then
 bell;
 Message(:rules);
    raise form_trigger_failure;
end if;
elsif :rules = 'Must Contain @' then
if not instr(:wvi, '@') > 0 then
 bell;
 Message(:rules);
     raise form_trigger_failure;
end if;
elsif :rules = 'Must Contain Date Only' then
declare
d date;
Begin
  d := to_date(:wvi, 'DD-MM-YYYY');
exception
when others then
   bell;
   Message(:rules);
   raise form_trigger_failure;
end;
end if;

Ask Your Questions By Comment Below.

Example given to validation a text item in Oracle forms using when validate item trigger and using bell, raise form_trigger_failure command.

Post a Comment

More Topics

V. Kapoor

{picture#https://3.bp.blogspot.com/-q3wCssWUHo8/ViDFfCpPEuI/AAAAAAAAD0M/MHPvgnl3T3U/s1600/authpic.JPG} Vinish Kapoor is a Software Consultant, currently working in a reputed IT company in Noida, India and doing blogging on Oracle Forms, SQL and PLSQL topics. He is an author of an eBook Oracle Forms Recipes, which is available on Google play. {facebook#https://www.facebook.com/foxinfotech2014} {twitter#https://twitter.com/foxinfotech} {google#https://plus.google.com/u/0/+VKapoor/posts}
Fox Infotech. Powered by Blogger.