Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

validate when comiting

Tony007Jan 28 2016 — edited Jan 31 2016

hi am in form 11gr2 how can I do this validation

I try this

if :some.field1 is null then

  if :some.field2 is null then

  if :some.field3 != null then

   if :some.field4 != null then

  message('The field is Mandatory');

    raise form_trigger_failure;

  end if;

  end if;

  end if;

  end if;

 

 

 

  field3  ********

  field4    ********

 

 

  field1  ******

  field2    ******

 

 

  validate when commit

 

  requrement

 

  if field3 and field4  are null than

     dont validate field1 and field2

    

     BUT

    

     IF THERE IS VALUE IN field3 and field4  THAn VALIDATE

     field1 and field2

This post has been answered by HamidHelal on Jan 29 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 28 2016
Added on Jan 28 2016
8 comments
1,402 views