OraFAQ Forum: Forms » capturing ORA-02396 in forms

Home » Developer & Programmer » Forms » capturing ORA-02396 in forms

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

capturing ORA-02396 in forms [message #168001]

Tue, 18 April 2006 06:05

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

In the Database side the DBA’s are setting a 20 mintues timeout.

In the application on the Form we need to capture the error message ORA-02396 and display the display the message as shown below:
ORA-02396: exceeded maximum idle time, please connect again

How is that possible to capture this error in the application on the Forms.

Any one have any idea.

Nirmal

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168009 is a reply to message #168001]

Tue, 18 April 2006 06:51

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Can't you use the ON-ERROR trigger?

MHE

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168013 is a reply to message #168009]

Tue, 18 April 2006 07:00

nirmalnarayan
Messages: 261
Registered: April 2005
Location: India

Senior Member

Sorry, the question is 'How to capture this', this error happens on the database side when the idle time exceeds,

if i try to capture it in the on-error, it will capture this only when a error happens on the forms right ?, or will it fire as soon as the idle time error fires at the database side, the question is how to invoke it in the form level, so that the on-error can check for this error ?

Thanks

Nirmal

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168026 is a reply to message #168013]

Tue, 18 April 2006 08:18

Maaher
Messages: 7065
Registered: December 2001

Senior Member

I think you should be looking for DBMS_ERROR_TYPE and DBMS_ERROR_CODE.

MHE

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168104 is a reply to message #168001]

Tue, 18 April 2006 18:42

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

Senior Member
Account Moderator

I think that a couple of the installations at which I have worked have tried to do this. Unfortunately there is this slight problem, the database has KILLED the session, therefore when the form tries to do something there is NO SESSION therefore there are NO MESSAGES. Try the DBMS error bits and pieces but as you have no session, the only message I expect you to receive is that there is 'no session'. You could keep a running store of the time of the last command and if the time of the next command is more that 20 minutes then a 'no session found' message could be interpreted as a time-out.

David

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168153 is a reply to message #168104]

Wed, 19 April 2006 01:45

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Right David, thanks for the correction. I seem to recall a similar thread from the past addressing the same issue.

MHE

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168161 is a reply to message #168153]

Wed, 19 April 2006 02:35

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

Senior Member
Account Moderator

I didn't look for any past threads but I would be VERY happy to hear of a way to handle this problem.

David

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168170 is a reply to message #168161]

Wed, 19 April 2006 03:17

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Have you seen Metalink doc 570378.994? Perhaps that's an option (didn't test it though).

MHE

Report message to a moderator

Re: capturing ORA-02396 in forms [message #168174 is a reply to message #168170]

Wed, 19 April 2006 03:27

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

Senior Member
Account Moderator

I wonder if that Metalink document is for Forms 10g on 10g AS and DB? I know it didn't work for 9iR2 Forms on 9iR2 AS because the stupid AS didn't receive the signal from the 9iR2 DB. We could time out the AS but the DB process wouldn't stop.

David

Report message to a moderator

Previous Topic:	lock delete or update or insert
Next Topic:	Problem in set_block_property

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:14:52 CDT 2024