Examine this code: 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: DECLARE TYPE databuf_arr IS TABLE OF CLOB INDEX BY BINATY_INTEGER; pdatabuf databuf_arr; PROCEDURE mytemplob (x OUT CLOB) IS BEGIN DBMS_LOB.CREATETEMPORARY (x, TRUE, DBMS_LOB, SESSION); END; BEGIN mytemplob (pdatabuf (1)); END; /
D.
pdatabuf (1) := NULL; should be added after line 4.
This section is not available anymore. Please use the main Exam Page.1z0-148 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Wrath
Highly Voted 5 years, 5 months agochrishillinger
Most Recent 2 years, 8 months agoCosminCof
4 years, 5 months agoAdela_bg
4 years, 10 months ago