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.
D.
Syntax
DBMS_LOB.LOADFROMFILE (
dest_lob IN OUT NOCOPY BLOB,
src_file IN BFILE,
amount IN INTEGER,
dest_offset IN INTEGER := 1,
src_offset IN INTEGER := 1);
dest_lob – LOB locator of the target for the load.
src_file – BFILE locator of the source for the load.
http://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_lob.htm#BABDDFDH
docs.oracle.com/cd/B28359_01/appdev.111/b28393/adlob_working.htm#i1007838
D