Insert Multiple images in oracle apex using collection

Page 7

1.  P7_ID

2. Attachment   -Page link 8 

3. Save button 

Plsql Code-- Set Save button

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 =c001) 

    FROM  APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';

    END;

    begin

    apex_collection.delete_collection(p_collection_name =>'DATA_COLLECTION_FILE');

    end;

  END IF;

Page 8

• P8_IMAGE
• add
• refresh

--Dynamic Action 

 Execute Pl/SQl Code 

IF apex_collection.collection_exists('DATA_COLLECTION_FILE') THEN

apex_collection.delete_collection('DATA_COLLECTION_FILE');

end if;

--refresh region report 

• add button 

--Processing 

 Execute Pl/SQl Code 

  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_c001=>:P8_IMAGE);

end;

---report in 8 page 

SELECT SEQ_ID,c001 FILE_NAME from APEX_COLLECTIONS where COLLECTION_NAME='DATA_COLLECTION_FILE';