Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Problem In Switching Connection (Windows Server 2012, Forms12.2.1.2.0,Databse 12c )
Problem In Switching Connection [message #672627] Sat, 20 October 2018 00:03 Go to previous message
deepakmannazhi
Messages: 136
Registered: February 2010
Location: Dubai, UAE
Senior Member

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





 
Read Message
Read Message
Previous Topic: Create ShortCut to run Allpication in 10g form
Next Topic: Unable to bind portable JNDI name error
Goto Forum:
  


Current Time: Sat Jan 25 12:26:12 CST 2020