What correction must be done to ensure the PL/SQL block executes successfully?

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

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