Database error during file upload

[Andersonq17]

Hello Daniel,
I'm getting this error 'Database error during file upload' and I did the steps you described in this plug in.

any idea why this error?

here is my setup

and here is my pl/sql code:

`DECLARE
-- get files data from saved apex_collection
CURSOR l_cur_files IS
SELECT c001 AS filename,
c002 AS mime_type,
d001 AS date_created,
n001 AS file_id,
blob001 AS file_content
FROM apex_collections
WHERE collection_name = 'DROPZONE_UPLOAD';
BEGIN
-- loop over files cursor
FOR l_rec_files IN l_cur_files LOOP
-- do whatever processing is required prior to the insert into your own table
INSERT INTO DOCUMENTS (
NAME,
MIME_TYPE,
LAST_UPDATED,
BLOB_CONTENT,
TASK_ID

) VALUES (
    l_rec_files.filename,
    l_rec_files.mime_type,
    l_rec_files.date_created,
    l_rec_files.file_content,
    :P10_TASK_ID
    
);

END LOOP;
-- clear original apex collection (only if exist)
IF apex_collection.collection_exists(p_collection_name => 'DROPZONE_UPLOAD') THEN
apex_collection.delete_collection(p_collection_name => 'DROPZONE_UPLOAD');
END IF;
END;`

[ferenciso]

tengo el mismo problema, pudiste solucionarlo?

[Thobanip6]

Did you guys find the solution for this? I'm experiencing the same issue.