Question 18:
See the Exhibit:
DATA_FILES is a directory object that contains the DETAILS.txt text file. You have the required permissions to access the directory object. You have a table using the following command: CREATE TABLE clob_tab(col2,CLOB); Examine the PL/SQL statement in exhibit that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error. What correction must be done to ensure the PL/SQL block executes successfully?
Answer options:
A. The L_OUT variable must be initialized to an empty locator B. The L_OUT variable has to be declared as a temporary LOB C. The A_CLOB variable has to be declared as a temporary LOB D. The clause RETURINING col2 INTO a a_clob should be added to the INSERT statement to correctly initialize the locator