-- sql
declare
temp_image clob default empty_clob();
image2 clob default empty_clob();
begin
image2 := 'data:image/png;base64,';
temp_image := 'abc...(less then 32767 character)';
dbms_lob.append(image2, temp_image);
temp_image := 'def...(less then 32767 character)';
dbms_lob.append(image2, temp_image);
Insert into DM_BASE_DATALOGO (ID,IMAGE) values (2, image2);
COMMIT;
end;
/
declare
temp_image clob default empty_clob();
image2 clob default empty_clob();
begin
image2 := 'data:image/png;base64,';
temp_image := 'abc...(less then 32767 character)';
dbms_lob.append(image2, temp_image);
temp_image := 'def...(less then 32767 character)';
dbms_lob.append(image2, temp_image);
Insert into DM_BASE_DATALOGO (ID,IMAGE) values (2, image2);
COMMIT;
end;
/