In Oracle Forms 12, I am using the default login screen to enter a form, the code I have in the ON-LOGON trigger is this:
declare
v_sid varchar2(100);
begin
tool_env.getvar('SID', v_sid);
logon('', v_sid);
end;
I also have an ON-ERROR trigger with this code:
if error_type ='FRM' then
if error_code in (40401, 40405) then
clear_message;
else
raise form_trigger_failure;
end if;
else
raise form_trigger_failure;
end if;
It works as intended when I enter a user ID, a password, and click CONNECT.
However, when I click CANCEL (regardless of what is enterred in the user ID and password fields, they can be empty), I am taken to the form without any warning or error. In other words, I am able to enter the application without entering any credentials.
Please help with fixing this issue, thank you.
