Upload Document and Download Document In Directory
1. Create Directory in Database and provide grant to directory >>> create directory dir_xxapex as '/apexshare'; >>> grant read,write on directory dir_xxapex to xx_apex; Also Provide folder permission to pubic 2. Create Table CREATE TABLE xxapex_documents ( do_doc_no NUMBER, do_doc_reftable VARCHAR2(250), do_doc_refid NUMBER, do_doc_file BLOB, do_file_name VARCHAR2(250), do_mime_type VARCHAR2(250), do_created_by VARCHAR2(255), do_created_date TIMESTAMP, do_last_updated_by VARCHAR2(255), do_last_updated_date TIMESTAMP ) 3.Create Report with Form pag...