Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Login possible when clicking Cancel on the default Forms login window (LOGON built-in) Forms 12

goodluck247Dec 6 2023 — edited Dec 7 2023

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.

This post has been answered by Michael Ferrante-Oracle on Dec 6 2023
Jump to Answer
Comments
Post Details
Added on Dec 6 2023
9 comments
271 views