What must be the value in the ADVT_SOURCE column for the above code to execute successfully?

Examine the structure of the PRINT_MEDIA table:
Name Null? Type
————— ——– ———
ADVT_ID NUMBER
ADVT_SOURCE CLOB

Examine the following PL/SQL block:
DECLARE
lobloc CLOB;
buffer VARCHAR2(100);
amount NUMBER;
offset NUMBER :=1;
BEGIN
buffer :=’This is the second line of a new document’;
amount := LENGTH(buffer);
SELECT advt_source INTO lobloc FROM print_media WHERE advt_id=2 FOR UPDATE;
DBMS_LOB.WRITE(lobloc,amount,offset,buffer);
COMMIT;
END;
/
What must be the value in the ADVT_SOURCE column for the above code to execute successfully?

Examine the structure of the PRINT_MEDIA table:
Name                  Null?          Type
—————           ——–        ———
ADVT_ID                           NUMBER
ADVT_SOURCE                  CLOB

Examine the following PL/SQL block:
DECLARE
lobloc CLOB;
buffer VARCHAR2(100);
amount NUMBER;
offset NUMBER :=1;
BEGIN
buffer :=’This is the second line of a new document’;
amount := LENGTH(buffer);
SELECT advt_source INTO lobloc FROM print_media WHERE advt_id=2 FOR UPDATE;
DBMS_LOB.WRITE(lobloc,amount,offset,buffer);
COMMIT;
END;
/