nerdexam
Oracle

1Z0-151 · Question #49

You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code…

The correct answer is E. Save the library. G. Attach the library to the orders form. H. Change the way the program unit is called in the Orders form. E: Save and compile the library. G: select the Attached Libraries node and click Create. In the Attach Library dialog box, click Browse to navigate to the saved library and open it, then answer Yes to the alert that asks if you want to remove the path. H: Modify the to simply…

Working with Forms Modules

Question

You are using a PL/SQL program unit in the Orders form to display an image for the selected product in the Order Items block. The code is called from several different triggers in the form. The code (with line numbers added) is: 1. PROCEDURE get_image IS 2. Product_image_id ITEM := FIND_ITEM ('control.product_image'); 3. Filename VARCHAR2(250); 4. BEGIN 5. Filename := TO_CHAR(:order_items.product_id) | | '.jpg'; 6. READ_IMAGE_FILE (filename, 'jpeg', product_image_id); 7. END; Management wants all codes to be in PL/SQL libraries to facilitate reuse. You create a PL/SQL library and drag the program unit from the orders form to the Program Units node of the library. You then delete the program unit from the Orders form. What three things must you do to compile the PL/SQL library and to use the code in the Orders form?

Options

  • AChange line 5 to:
  • Binsert the RELEASE keyword between lines 1 and 2.
  • CDelete the BEGIN and END statements (lines 4 and 7).
  • DChange product_id to an in parameter and filename to an OUT parameter.
  • ESave the library.
  • FGenerate the a .plx file.
  • GAttach the library to the orders form.
  • HChange the way the program unit is called in the Orders form.

How the community answered

(66 responses)
  • B
    11% (7)
  • C
    5% (3)
  • D
    2% (1)
  • E
    82% (54)
  • F
    2% (1)

Explanation

E: Save and compile the library. G: select the Attached Libraries node and click Create. In the Attach Library dialog box, click Browse to navigate to the saved library and open it, then answer Yes to the alert that asks if you want to remove the path. H: Modify the to simply call the procedure from the attached library:

Topics

#PL/SQL library#attached library#program unit reuse#library generation

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-151 Practice