Hello,
I have a change password page.
There are 4 items on the page
PX_USERNAME - Hidden text area contents source from &APP_USER.
PX_OLD_PASSWORD - Visible text area source from user input.
PX_NEW_PASSWORD - Visible text area source from user input.
PX_NEW_PASSWORD_2 - Visible text area source from user input.
There is one validation to check that the user inputs identical values for new password.
I want to add a validation to check that the old_password is true and have attempted to place the following validation with type "Function Returning Boolean".
BEGIN
IF
(SELECT password
FROM sfm_common.sct_parties
WHERE password = custom_auth(:p12_username, :p12_old_password));
THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;
The above does not work and displays the following error in APEX.
ORA-06550: line 4, column 6: PLS-00103: Encountered the symbol "SELECT" when expecting one of the following: ( - + case mod new not null others avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date pipe ORA-06550: line 6, column 71: PLS-00103: Encountered the symbol
Error ERR-1021 Unable to run "function body returning boolean" validation.
Thank You
Ben