OraFAQ Forum: Forms » how to exit from long fetching

Home » Developer & Programmer » Forms » how to exit from long fetching

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

how to exit from long fetching [message #123682]

Tue, 14 June 2005 07:59

sneha_84
Messages: 21
Registered: May 2005

Junior Member

Dear Friends,

I am working with Oracle8i and D2k 2.1

I request to fetch and display huge amount of data into a form.

where as it will take 10-20 minutes to dispaly.

When I want to exit from the fetching process how I can activate cancel button immediately.

I mean when fetching process is on it wont respond for any other events at all.

what to do for an emergency exit from form by cancel button.

Advance thanks.

Report message to a moderator

Re: how to exit from long fetching [message #123685 is a reply to message #123682]

Tue, 14 June 2005 08:01

sneha_84
Messages: 21
Registered: May 2005

Junior Member

Friends,

I am working with Oracle8i and D2k 2.1

I request to fetch and display huge amount of data into a form.

where as it will take 10-20 minutes to dispaly.

When I want to exit from the fetching process how I can activate cancel button immediately.

I mean when fetching process is on it wont respond for any other events at all.

what to do for an emergency exit from form by cancel button.

Advance thanks.

Report message to a moderator

Re: how to exit from long fetching [message #123816 is a reply to message #123685]

Wed, 15 June 2005 00:08

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

Senior Member
Account Moderator

This has been a problem since the first days of Oracle. Once control has been passed to the database you have to wait for the database to reply. As of 9i there is a method of interrupting the query (but I can't remember just now, I will have to research it).

May I suggest that you spend time tuning your query. Does it take 20 minutes to return if you run the query in SQL*Plus. If not, then look at what is different between your form's query and your SQL*Plus query.

Sorry.

David

Report message to a moderator

Previous Topic:	FormLauncher error
Next Topic:	...Key Events...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 08 07:21:34 CST 2025