The anonymous block fails with:
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 5
Which two are valid options to prevent this error from occurring?
A. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1),
TRUE, DBMS_LOB.CALL);
B. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf (1),
FALSE, DBMS_LOB.SESSION);
C. Rewrite the block as:DECLARETYPE databuf_arr IS TABLE OF CLOB INDEX BY
BINATY_INTEGER;pdatabuf databuf_arr;PROCEDURE mytemplob (x OUT CLOB)
ISBEGINDBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB,
SESSION);END;BEGINmytemplob (pdatabuf (1));END;/
D. pdatabuf (1) := NULL; should be added after line 4.
E. Line 5 should be replaced with:DBMS_LOB.CREATETEMPORARY (pdatabuf, TRUE,
DBMS_LOB.SESSION);
Answer: C,E
Visit For More Information: 1Z0-148 Braindumps
