Forum Stats

  • 3,750,525 Users
  • 2,250,188 Discussions
  • 7,866,998 Comments

Discussions

FRM-40007 :- Invalid user identifier or password during middle of forms operation

Deepak
Deepak Member Posts: 8 Blue Ribbon

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','[email protected]' || 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','[email protected]' || 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

Answers

  • Michael Ferrante-Oracle
    Michael Ferrante-Oracle Senior Principal Product Manager USMember Posts: 6,803 Employee

    Something else is likely going on that you have yet to identify. However, for starters, I would suggest adding SYNCHRONIZE to the code. For example:

       :Global.DbUser := Get_Application_Property(USERNAME);
       SYNCHRONIZE;
       call_form('FORM');
    


    Deepak