Hello, I have created a process which loads the data from user table into my edit profile form page.
begin
select user_id, fname, lname, email
into :P15_USER_ID, :P15_FNAME, :P15_LNAME, :P15_EMAIL
from user
where email = :APP_USER;
exception
when no_data_found then
:P15_USER_ID := null;
:P15_FNAME := null;
:P15_LNAME := null;
:P15_EMAIL := null;
end;
However, I have encountered this error APEX.PROCESS.INVALID_EDITABLE_REGION as shown below. Hence, null was returned for all fields.
Does anyone know why this may be so? And, any thoughts on how I could solve this error? Thank you so much in advance!