nerdexam
Oracle

1Z0-151 · Question #28

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…

The correct answer is B. Before the line of code that executes the query, add the line. 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 When-New-Form-Instance trigger will prevent the unwanted updates that…

Design Considerations for PL/SQL Code

Question

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?

Options

  • ABefore the line of code that executes the query, add the line:
  • BBefore the line of code that executes the query, add the line:
  • CUse the SET_APPLICATION_PROPERTY built-in to set the message level in a When-New- Form-instance
  • DYou do not need to do anything, the default behavior of Forms is to display the "Working" message

How the community answered

(25 responses)
  • A
    4% (1)
  • B
    72% (18)
  • C
    16% (4)
  • D
    8% (2)

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 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'); Go_Block ('EMP'); Go_Block ('DEPT'); System.Suppress_Working := 'FALSE';

Topics

#Working message#SET_APPLICATION_PROPERTY#message suppression#form behavior

Community Discussion

No community discussion yet for this question.

Full 1Z0-151 Practice