apex-plugin-dropzone
apex-plugin-dropzone copied to clipboard
Database error during file upload
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;`
tengo el mismo problema, pudiste solucionarlo?
Did you guys find the solution for this? I'm experiencing the same issue.