Dear Experts,

We have 3 Different Schema(DB User) in Our Application.

Application is connecting to User ABC

ABC/ABC@DB01

this we mentioned in formsweb.cfg.

After login

	call_form('Comp_Sele');

We are using separate buttons to connect to Different Schemas.

Using LOGOUT, LOGIN procedures.


IN WHEN-BUTTON-PRESSED TRIGGER WE ARE USING

BUTTON 1

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('XYZ','XYZ@' || the_connect);

BUTTON 2

 
  the_connect  := Get_Application_Property(CONNECT_STRING); 
  logout;
  logon('TUV','TUV@' || the_connect);

This press event will navigate to another screen, from that screen when we press button to move to another screens, we are getting error showing invalid user id

ORA-01017: invalid username/password; logon denied


Is there any limitations in 12c for switching connections using LOGON procedure?


Thanks and Best Regards
Deepak