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?

Question

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?

Accepted Answer

D. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly

Answer

A. The L_OUT variable must be initialized to an empty locator.

Answer

B. The L_OUT variable has to be declared as a temporary LOB.

Answer

C. The A_CLOB variable has to be declared as a temporary LOB.

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…

Question

Exhibit

Options

How the community answered

Community Discussion