Dear Experts,
we have two divisions in our application. Both are created as different schemas
DIVISION1 AND DIVISION2 in addition to this, we have a main schema, through which the first connection is happening.
From the main screen, users can navigate to each division using DIVISION1 AND DIVISION2 Buttons
WHEN BUTTON PRESSED IN DIVISION1
Code: [Select all] [Show/ hide]
declare
the_connect varchar2(20);
begin
the_connect := Get_Application_Property(CONNECT_STRING);
logout;
logon('DIVISION1','DIVISION1@' || the_connect);
:Global.DbUser := Get_Application_Property(USERNAME);
call_form('FORM');
end;
WHEN BUTTON PRESSED IN DIVISION2
Code: [Select all] [Show/ hide]
declare
the_connect varchar2(20);
begin
the_connect := Get_Application_Property(CONNECT_STRING);
logout;
logon('DIVISION2','DIVISION2@' || the_connect);
:Global.DbUser := Get_Application_Property(USERNAME);
call_form('FORM');
end;
This is working. But sometimes we are getting
Quote:
FRM-40007 :- Invalid user identifier or password
error.
This is not happening all the time, but occasionally we are getting this error. After monitoring few days, we found that this error is happening when the user do switching between divisions(schemas) continuously.
Hope I explained the issue properly.
Could you please help me to solve this issue
Thanks and best Regards
Deepak