Home » Developer & Programmer » Forms » ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114
ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #233050] Tue, 24 April 2007 08:14 Go to next message
kbsonal
Messages: 3
Registered: April 2007
Junior Member
Hi everyone,

I used oracle 6i forms and reports which works fine
then
I have to install .net framework 2.0 when I install i saw that framework doesnt accept my oracle connection
then I install 10g client tool and now I have big problem with my oracle forms
when I opened the designer mode it seems no problem it works fine and I can easily compile the form but when I try to run the program I have 'ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114'

but when I use my local database it works fine.
(my local database 9i, other database 10g)


Kivanc

Re: ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #233691 is a reply to message #233050] Fri, 27 April 2007 03:16 Go to previous messageGo to next message
ahmdmero2002
Messages: 1
Registered: April 2007
Location: Egypt
Junior Member

Hi

Try to add exception block at the botton of the procedure
i think it might help

ahmed
Re: ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #233731 is a reply to message #233691] Fri, 27 April 2007 04:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How would exception handler solve "not connected to Oracle" error?

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.


So, how does the ON-ERROR trigger look like?
Re: ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #236447 is a reply to message #233050] Thu, 10 May 2007 00:51 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #236478 is a reply to message #236447] Thu, 10 May 2007 01:28 Go to previous messageGo to next message
kbsonal
Messages: 3
Registered: April 2007
Junior Member
no i havent solve the problem.

I will format my pc then
i will install 10g server then
ı will install forms and report builder

thanks for your replys
Re: ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #236791 is a reply to message #236478] Fri, 11 May 2007 00:55 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You don't have to format your PC but if you can't get the Oracle stuff to uninstall properly then just delete the 'oracle' directory and in 'regedit' delete the 'oracle' tree. This way the 'oracle home' counter will start from zero again.

David
Previous Topic: a strange problem
Next Topic: Insert and Read a BLOB using Forms 6i
Goto Forum:
  


Current Time: Fri Dec 09 19:19:01 CST 2016

Total time taken to generate the page: 0.08399 seconds