Hello Everyone,
I have a problem to add blob data in collection. How to solve this ??
ADD button → Dynamic Action → Execute Server-side Code →
declare
filename VARCHAR2(255);
blob_content blob;
mimetype VARCHAR2(255);
begin
IF NOT apex_collection.collection_exists ('EMPIMG_COLL') then
apex_collection.create_collection ('EMPIMG_COLL');
END IF;
select blob_content, filename, mime_type
into blob_content, filename, mimetype
from apex_application_temp_files
where name = :P73_FILE_BLOB;
apex_collection.add_member(
p_collection_name => 'EMPIMG_COLL',
p_c001 => filename,
p_c002 => mimetype,
p_blob001 => blob_content,
p_c003 => :P73_EMPNAME,
p_c004 => :P73_SALARY,
p_c005 => :P73_ISACTIVE
);
commit;
end;