Message while running a procedure [message #79714] |
Thu, 04 July 2002 14:20 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
JD.Dutt
Messages: 9 Registered: December 2001
|
Junior Member |
|
|
I want to give a message "Please Wait, System is Busy" when the system is busy in executing a local procedure or performing some task.
Can anybody tell me how to give display this kind of messages, very much required, Urgent.
Thanks in advance.
|
|
|
Re: Message while running a procedure [message #79718 is a reply to message #79714] |
Thu, 04 July 2002 21:03 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
You can do like this
message('Please Wait, System is Busy');
synchronize;
set_application_property(CURSOR_STYLE,'BUSY');
Your procedure coding......
message('');
synchronize;
set_application_property(CURSOR_STYLE,'default');
pls let me know if this works..
|
|
|
Re: Message while running a procedure [message #79727 is a reply to message #79718] |
Fri, 05 July 2002 08:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
JD.Dutt
Messages: 9 Registered: December 2001
|
Junior Member |
|
|
Hi,
Thanks For your valuable suggestion.
I have written the suggested code as follows.
Assume i have procedure 'A' and a button B.
IN When_button_Pressed of B, i have written code as below,
Declare
Begin
message('Please Wait, System is Busy');
synchronize;
set_application_property(CURSOR_STYLE,'BUSY');
A; /* Call to Procedure A */
message('');
synchronize;
set_application_property(CURSOR_STYLE,'default');
....
.....
........
..............
End;
Everything is fine except i am getting a popup window(alert window) with message "Please Wait, System is Busy" and a OK button after the Procedure A's execution is completed.
I don't want this POPUP window to come, the system should continue the process without displaying the POPUP window.
Can you please give the solution.
Thanks.
|
|
|
Re: Message while running a procedure [message #79734 is a reply to message #79718] |
Fri, 05 July 2002 23:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Ravi
Messages: 251 Registered: June 1998
|
Senior Member |
|
|
Ok Dutt I got your problem...
Do like this
instead of using this statment "message(' ')" call a buitin "Clear_Message".
That means your code should be like this :
Declare
Begin
message('Please Wait, System is Busy');
synchronize;
set_application_property(CURSOR_STYLE,'BUSY');
A; /* Call to Procedure A */
clear_message;
synchronize;
set_application_property(CURSOR_STYLE,'default');
....
.....
........
..............
End;
let me know if this works
|
|
|