OraFAQ Forum: Forms » ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114

Home » Developer & Programmer » Forms » ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-40735: ON-ERROR trigger raised unhandled exception ORA-03114 [message #233050]

Tue, 24 April 2007 08:14

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

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21818
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?

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

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

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 26 22:55:51 CDT 2024