DATA_FILES is a directory object that contains the DETAILS.TXT text file.
You have the required permissions to access the directory object.
You create a table using the following command:
CREATE TABLE clob_tab(col2 CLOB);
View the Exhibit and examine the PL/SQL block 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?
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 RETURNING col2 INTO a_clob should be added to the INSERT statement to
correctly initialize the locator.
a_clob is neither temporary LOB nor persistent LOB in connection with one LOB column, I think there would be one error occuring when call DBMS_LOB.LOADFROMFILE
D