Home » Developer & Programmer » Forms » Logon_Screen Built in errror
Logon_Screen Built in errror [message #377665] Wed, 24 December 2008 02:29 Go to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
In forms 10g i have written the following code in when-button-pressed trigger

When i press this button forms has to display default log on screen and has to swith to the any other databases. But this is raising error and displays error_code as 0(Zero).

Begin
Logout;
Logon_Screen;
Pkg.A;
Exception
When Others Then
Message(Error_Code||' '||Error_Text);
End;

Thanks in advance
Re: Logon_Screen Built in errror [message #377679 is a reply to message #377665] Wed, 24 December 2008 03:54 Go to previous messageGo to next message
cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you remove the exception when others what happens?
Re: Logon_Screen Built in errror [message #377878 is a reply to message #377679] Fri, 26 December 2008 00:37 Go to previous messageGo to next message
sathyam2627
Messages: 52
Registered: November 2006
Member
Hi,

If we remove exception its raising exception ora-03114

Thanks
Re: Logon_Screen Built in errror [message #377933 is a reply to message #377878] Fri, 26 December 2008 08:28 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-03114 not connected to ORACLE

Cause: A call to Oracle was attempted when no connection was established. Usually this happens because a user-written program has not logged on. It may happen if communication trouble causes a disconnection. In addition, this message could occur when ALTER SYSTEM KILL SESSION or ALTER SYSTEM DISCONNECT SESSION were issued with the IMMEDIATE qualifier because, in those cases, the client's connection to the database is terminated without waiting for the client to issue a request.

Action: Try again. If the message recurs and the program is user written, check the program.
Previous Topic: Retrieving records
Next Topic: Insert new Row on Tabular style form
Goto Forum:
  


Current Time: Sun Feb 09 09:54:01 CST 2025