Skip to Main Content

APEX

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!

How to stop page refresh if Validation fails in oracle apex 5

Diganta01Oct 22 2016 — edited Oct 24 2016

Hi All,

I have written a PL/SQL code to check validation on a manual form with radio buttons. I have written the validation PL/SQL and it is called when Submit button is clicked. I want to stop page refresh if validation fails. My Validation code is below:

Validation code

if apex_application.g_f01.count = 0 then

apex_error.add_error( 

    p_message          => 'Not Answered: ' || apex_application.g_f11(1), 

    p_additional_info  => null, 

    p_display_location => apex_error.c_inline_in_notification);

    return FALSE;

End If;

Note

I have used Function returning Boolean in Type field of Validation.

Please help.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2016
Added on Oct 22 2016
4 comments
1,449 views