The following lines contain the word 'select', 'insert', 'update' or 'delete':
select fnd_lobs_s.nextval
from dual;
--insert an empty lob into fnd_lobs
insert
into
fnd_lobs
(file_id,
file_name,
file_content_type,
file_data,
upload_date,
file_format,
program_name
)
values
(
l_LOB_ID,
p_file_name,
'image/html',
empty_blob(),
sysdate,
'image',
'AMS_CONTENT'
)
returning file_data into Dest_Loc;