Search code examples
oracle-apex

Oracle APEX - validation returns a wrong value

I created a validation for checking the current password. This is the PL/SQL code: enter image description here

When I enter the correct password, it gives me an error message like this: enter image description here

I wanted to check what is the value of old_pwd, so I changed the validation type to Function Body (returning Error Text) and then changed the code like this: enter image description here

Then, somehow, the value of old_pwd becomes 'ABC', which I entered in the New Password field. enter image description here

I have no idea why this happens. Can anyone help me?

[EDIT]

It might not be related, but I have a process after submitting it. It is like this: enter image description here

Solution

  • Move the "Submit" process from After Submit to Processes. server side condition-> when button pressed "submit" button.

    Reason being- enter image description here