Unable to upload file as blob to table using Oracle APEX

yyy62103 0
Viewed 38

I have a application built using Oracle APEX 20.x.

The issue is need to programmatically upload the (.pdf,.txt,.png,.jpeg,.jpg) as a BLOB to table

I heard about the APEX_APPLICATION_TEMP_FILES.

How to utilize this table to upload my file as BLOB to this following table using Insert statement?

I want to achieve this activity on Button click -> dynamic action -> PLSQL coding

apex-code oracle-sqldeveloper oracle-apex plsqldeveloper oracle
1 Answers

here on Stackoverflow, there are great examples about it. but in a nutshell:

if :P1_MY_FILE is not null then
 select blob_content, filename, mime_type 
 into l_req_file, l_req_file_name, l_req_mime_type 
 from apex_application_temp_files 
 where name = :P1_MY_FILE ;
end if;

should give the idea

Oguen0
Related