Home » Developer & Programmer » Forms » Logon to another database
Logon to another database [message #431555] Wed, 18 November 2009 02:14 Go to next message
sysman2007
Messages: 24
Registered: March 2009
Junior Member
in my form I have 2 radio button and want when user click on it
connection change from this database to another database?
I try to do this whit LOGOUT and LOGON but don't work.
for example when user click on 1th radio button connect to 1th database
and when user click on 2th radio button connect to 2th database
Re: Logon to another database [message #431568 is a reply to message #431555] Wed, 18 November 2009 03:50 Go to previous messageGo to next message
Littlefoot
Messages: 21821
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Wouldn't you rather do that during connection to the application? You have to supply username, password and database you are connecting to. So ... why not?
Re: Logon to another database [message #431592 is a reply to message #431568] Wed, 18 November 2009 06:21 Go to previous messageGo to next message
sysman2007
Messages: 24
Registered: March 2009
Junior Member
I use 2 database in 2 servers but username and password of users in
2 servers is same as other.
I want help users to prevent 2 times logon an enter 2 times username and password.
Re: Logon to another database [message #431626 is a reply to message #431592] Wed, 18 November 2009 10:21 Go to previous messageGo to next message
snsiddiqui
Messages: 172
Registered: December 2008
Senior Member
Dear
You should use DBLINK instead of LOGOUT and LOGON.
Re: Logon to another database [message #431997 is a reply to message #431555] Fri, 20 November 2009 05:52 Go to previous messageGo to next message
dshakthi
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
please try this

declare
un varchar2 (10) := 'aaaa';
pw varchar2 (10) := 'bbbb';
cn varchar2 (10) := 'cccc';
aa varchar2 (100);
begin
logout;
logon (un, pw || '@' || cn);
select name into aa from v$database;
message ('database ' || aa);
message (' ');
end;
Re: Logon to another database [message #432071 is a reply to message #431997] Fri, 20 November 2009 22:11 Go to previous messageGo to next message
sysman2007
Messages: 24
Registered: March 2009
Junior Member
I use this codes
but I get error FRM-92101 when want LOGON to new database

FRM-92101: There was a failure in the forms Server during startup.This Could happen due to invalid configuration
Please look into the web-server log file for details.

Details
Java Exception
oracle.forms.net.connectionException: Forms session <25> aborted: unable to communicate with runtime process.
at oracle.forms.net.connectionException:createConnectionException(Unknown Source)
at oracle.forms.net.HTTPNStream.getResponse(Unknown Source)
at oracle.forms.net.HTTPNStream.doflush(Unknown Source)
at oracle.forms.net.HTTPNStream.flush(Unknown Source)
at java.io.DateOutputStream.flush(Unknown Source)
at oracle.forms.net.StreamMessageWritter.run(Unknown Source)
Re: Logon to another database [message #432242 is a reply to message #432071] Mon, 23 November 2009 03:25 Go to previous messageGo to next message
dshakthi
Messages: 5
Registered: January 2008
Location: Bangalore
Junior Member
try this out
  • Attachment: post.JPG
    (Size: 96.17KB, Downloaded 697 times)
Re: Logon to another database [message #432449 is a reply to message #432242] Tue, 24 November 2009 05:27 Go to previous messageGo to next message
sysman2007
Messages: 24
Registered: March 2009
Junior Member
thanks but didn't work
Re: Logon to another database [message #433366 is a reply to message #432449] Tue, 01 December 2009 23:40 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Have you solved your problem?

If not, try saving the username and password BEFORE doing the 'logoff', then use that information as part of the new 'logon'.

David
Previous Topic: Validation
Next Topic: Forms multi-row validation
Goto Forum:
  


Current Time: Mon Nov 04 11:30:41 CST 2024