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 *


ja

ja

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