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
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