OraFAQ Forum: Forms » Reconnect at form runtime

Home » Developer & Programmer » Forms » Reconnect at form runtime (Oracle form6, Oracle10g)

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

Reconnect at form runtime [message #437794]

Wed, 06 January 2010 01:04

salora
Messages: 26
Registered: December 2009
Location: Thailand

Junior Member

Any one pls help me. I have the question about connection to oracle DB as follwing...

Is it possible to disconnect and re-connect to DB. during oracle form runtime. Any one have the code to do that, pls help.

thank in advance

Report message to a moderator

Re: Reconnect at form runtime [message #437795 is a reply to message #437794]

Wed, 06 January 2010 01:09

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Quote:

Is it possible to disconnect and re-connect to DB.during oracle form runtime.

What do you mean by that ?
1)Connect to another DB?
2)If One connection failed then connect to another Db ?
And Why you need that ?

sriram Smile

Report message to a moderator

Re: Reconnect at form runtime [message #437798 is a reply to message #437795]

Wed, 06 January 2010 01:27

salora
Messages: 26
Registered: December 2009
Location: Thailand

Junior Member

Thank you for your reply.

The reason why need to disconnect, because we need to save the resource, as following sinario...

1. When user retrive data as per as the given criteria. Then we prefer to disconnect DB (to save the resource)
2. untill user need to do something more , then we will autometic reconnect again.

Is it possible to that in oracle form runtime.

Thank you for you help.
Sad

Report message to a moderator

Re: Reconnect at form runtime [message #437800 is a reply to message #437798]

Wed, 06 January 2010 01:46

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

I am totally confused with your reply.

When ever the User got the answer then you should disconnect.?

there are so many other ways to implement resource management.i think its not proper..but Here is one link which not the complete solution But try this hope that will help you..And some other will help you on this topic.
Here is the link

Good luck Smile

Sriram

Report message to a moderator

Re: Reconnect at form runtime [message #437806 is a reply to message #437800]

Wed, 06 January 2010 02:13

salora
Messages: 26
Registered: December 2009
Location: Thailand

Junior Member

Thank you so much, for your help Sriram. Smile

Report message to a moderator

Previous Topic:	Help on Host built-in
Next Topic:	HOW TO HIDE WEBUTIL INFORMATION AT STARTUP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 04:58:22 CST 2025