• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 953
  • Last Modified:

How to Multi-thread an Oracle Form ??

Hi,

When I query a block in my Form, the form hangs until the query returns the data. Now this might be default Forms behaviour but is there an option to 'multi-thread' the Form so that the block query runs in the backgorund, a bit like Excel where it doesn't lock the application.

Any ideas ?

CC
0
comradec
Asked:
comradec
  • 2
2 Solutions
 
Helena Markováprogrammer-analystCommented:
It cannot be done.
You can avoid such problems by setting Query All Records block property to NO.
Also you can create a block based on stored procedure.
0
 
sapnamCommented:
You can use the SET_APPLICATION_PROPERTY built-in to indicate to the user that the query is processing so that he does not get the feeling that the application has hanged.  Your KEY-EXEQRY will be like

SET_APPLICATION_PROPERTY(cursor_style,'BUSY');
synchronize;
MESSAGE('Executing query, please wait ....',NO_ACKNOWLEDGE);
synchronize;
EXECUTE_QUERY;
SET_APPLICATION_PROPERTY(cursor_style,'DEFAULT);
synchronize;
clear_message;
synchronize;
0
 
sapnamCommented:
Actually, the question was answered by Henka.  My post was a supplement to that. So I do not think I deserve to get all the points.
0
 
comradecAuthor Commented:
ok, thanks anyway, i do the busy cursor thing anyway. I wanted a multi threaded process....

cc
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now