Home » Developer & Programmer » Forms » Message while running a procedure
Message while running a procedure [message #79714] Thu, 04 July 2002 14:20 Go to next message
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 messageGo to next message
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 messageGo to next message
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
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
Previous Topic: Need Total REcords found in Enter Query Mode
Next Topic: No changes to save error on oracle9iAS
Goto Forum:
  


Current Time: Thu Apr 25 10:23:23 CDT 2024