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:
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?
A. Change line 5 to: filename := to_char(name_in ‘Order_Items.product_id’)) || ‘.jpg’;.
B. insert the RELEASE keyword between lines 1 and 2.
C. Delete the BEGIN and END statements (lines 4 and 7).
D. Change product_id to an in parameter and filename to an OUT parameter.
E. Save the library.
F. Generate the a .plx file.
G. Attach the library to the orders form.
H. Change the way the program unit is called in the Orders form
|
Download Printable PDF. VALID exam to help you PASS. |
 |