Home » Oracle » 1z0-151 » What can you do to stop the "Working" message from appearing?
Users do not want to see the "Working" message while a long query completes.
You are designing a form with a query that takes o long time to execute. What can you do to stop the "Working" message from appearing?
A. Before the line of code that executes the query, add the line:
:SYSTEM.MESSAGE_LEVEL := ’10’;
B. Before the line of code that executes the query, add the line:
:SYSTEM.SUPPRESS_WORKING : = TRUE’;
C. Use the SET_APPLICATION_PROPERTY built-in to set the message level in a When-New-Form-instance trigger.
D. You do not need to do anything, the default behavior of Forms is to display the "Working" message only if you add code to do so.
Correct Answer: B
Explanation/Reference:
Explanation:
You can turn the ‘Working…’ message off with system.suppress_working command.
SYSTEM.SUPPRESS_WORKING examples
Assume that you want to have the form filled with data when the operator enters the form. The following When-New-Form-Instance trigger will prevent the unwanted updates that would normally occur when you fill the blocks with data. :System.Suppress_Working :=
‘TRUE’;
Go_Block (‘DEPT’);
Execute_Query;
Go_Block (‘EMP’);
Execute_Query;
Go_Block (‘DEPT’);
:System.Suppress_Working := ‘FALSE’;
Download Printable PDF. VALID exam to help you PASS.
|
|