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
comradecAsked:
Who is Participating?
 
Helena MarkováConnect With a Mentor 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
 
sapnamConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.