Examine the structure of the LOB_STORE table.
Name Null? Type
—————- ——– ————
LOB_ID NUMBER
VIDEO_CLIP BLOB
You create a ‘DATA_FILES’ directory object that contains the ‘IMAGE1.GIF’operating system
(OS) file.
View the Exhibit and examine the LOAD_LOB procedure code that you execute for reading data
from the OS file into the BLOB column.
It is created with compilation errors.
What is the reason?
A.
V_BLOB should be initialized to EMPTY_BLOB().
B.
The WRITE routine of DBMS_LOB should be used instead of LOADFROMFILE.
C.
The return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement.
D.
OPEN, CLOSE, and READONLY routines of DBMS_LOB should be used instead of
FILEOPEN, FILECLOSE, and FILE_READONLY.
http://docs.oracle.com/database/121/ARPLS/d_lob.htm#ARPLS66675
V_BLOB is already initialized to EMPTY_BLOB(), A is incorrect.
http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_lob.htm#i999593
“This procedure writes a specified amount of data into an internal LOB, starting from an absolute offset from the beginning of the LOB. The data is written from the buffer parameter.”
Buffer should be of type raw or varchar2, so B is incorrect.
Function FILEEXISTS returns INTEGER and can not be used in IF statement. C is correct.
FILE_READONLY is a constant, not a routine. FILEOPEN and FILECLOSE routines can be used with BFILE, so D is incorrect.
ะก is correct.
C