apex-plugin-dropzone icon indicating copy to clipboard operation
apex-plugin-dropzone copied to clipboard

Database error during file upload

Open Andersonq17 opened this issue 5 years ago • 2 comments

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

dd1 dd2

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;`

Andersonq17 avatar Jan 16 '20 02:01 Andersonq17

tengo el mismo problema, pudiste solucionarlo?

ferenciso avatar Aug 03 '20 23:08 ferenciso

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

Thobanip6 avatar Oct 24 '22 10:10 Thobanip6