Oracle Exam 1Z0-151 Topic 7 Question 11 Discussion

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?