Using Apex Collection Insert Multiple Image File

Image Insert Into Apex Collection:
===============================
begin
if not apex_collection.collection_exists('DATA_COLLECTION_FILE') then
apex_collection.create_collection('DATA_COLLECTION_FILE');
end if;
apex_collection.add_member (
p_collection_name='DATA_COLLECTION_FILE',
p_c002=:P58_IMAGE);
end;
Show Uploaded Image:
=========================
SELECT SEQ_ID,c001 FILE_NAME from APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';
Insert Image File into database:
=============================
IF apex_collection.collection_exists('DATA_COLLECTION_FILE') THEN------------
BEGIN
INSERT INTO HOLDING_APPLICATION_ATTATCHMENT(HOLDING_APPLICATION_ID,IMAGE)
SELECT 101,(select blob_content from APEX_APPLICATION_TEMP_FILES where name =c002)
FROM APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';
END;
begin
apex_collection.delete_collection(p_collection_name ='DATA_COLLECTION_FILE');
end;
END IF;
#Oracle#apex #collection#insert multiple image#image#apexsolutions

[@kas6245]

lot of thanks

[@M.mohamedJabithali]

ORA-06550: line 3, column 17: PL/SQL: ORA-00942: table or view does not exist(HOLDING_APPLICATION_ATTATCHMENT)

[@kas6245]

thanks

[@arsalansharif1830]

Hi ! there is any option for bulk images upload in apex ??

[@OracleApexTutorials]

What do you mean by bulk Image upload ? You can insert multiple Image through Apex collection.

[@SazidAhmedNassir]

How can i show it on slider?

[@fip4070]

Image form a show korani jai kevabe ??

[@OracleApexTutorials]

You can show image in form using select query