[Apex 5.1]
Hello,
I have an apex application and I would like to create a page where the user can upload some files and store them in a certain table.
I'm doing this in a process. Here is the process code :
Begin
if :P98_DOCUMENT is not null then
Insert into Document
(Document, Category, User_, Comment_, DOCUMENT_MIMETYPE, DOCUMENT_FILENAME, DOCUMENT_LAST_UPDATE, DOCUMENT_CHARSET)
select
blob_content, :P98_DOCUMENTCATEGORY, 61, :P98_COMMENT, MIME_TYPE, FileName, Last_Update, FILE_CHARSET
from APEX_APPLICATION_TEMP_FILES where :P98_Document = NAME;
end if;
end;
The designer shows me an error saying that the fields Last_Update, FILE_CHARSET are not available in the table APEX_APPLICATION_TEMP_FILES.
Does anyone know please how to get such information from the table APEX_APPLICATION_TEMP_FILES ?
Thanks