insert multiple image using from temp file

   CREATE TABLE "TEST"."EMPLOYEE_PHOTO" 

   ( "ID" VARCHAR2(100 BYTE), 

"FILENAME" VARCHAR2(1000 BYTE), 

"MIME_TYPE" VARCHAR2(1000 BYTE), 

"PHOTO" BLOB, 

"EMPLOYEE_ID" VARCHAR2(1000 BYTE)

   )

---

• P10_NEW  -file browse 
• P10_ID -- ID 
• upload Button 

--create page load dynamic action 

Execute PL/SQL Code 

delete from APEX_APPLICATION_TEMP_FILES;

--Processing (upload )

DECLARE

CURSOR C1 IS 

SELECT ID,FILENAME,MIME_TYPE,BLOB_CONTENT

FROM APEX_APPLICATION_TEMP_FILES;

    

BEGIN

FOR REC_C1 IN C1 LOOP

INSERT INTO EMPLOYEE_PHOTO (ID,FILENAME,MIME_TYPE,PHOTO,EMPLOYEE_ID)

VALUES (REC_C1.ID,REC_C1.FILENAME,REC_C1.MIME_TYPE,REC_C1.BLOB_CONTENT,:P10_ID);

END LOOP;

    delete from APEX_APPLICATION_TEMP_FILES;

    

    

    END;