Batch PDF Upload to APEX
Budget: ₹1,500 – ₹12,500 INR
I’m running Oracle APEX 22.1 and need a clean, repeatable way to pull a set of PDF files that live on our local server into an APEX table (BLOB column plus a few metadata fields). The process has to be fully automated—no manual forms—so a PL/SQL‐driven job or an OS script that calls an APEX-ready API makes most sense.
Here’s what I picture: the job scans a nominated folder, ingests any new PDFs, stores them in the table, flags or archives the originals, and logs success or failure so I can audit the run. You’re free to choose the mechanics (UTL_FILE, DBMS_LOB, APEX_DATA_PARSER, SQL*Loader, or even a small Java/Python wrapper) as long as it plays nicely with APEX 22.1 and can be scheduled through DBMS_SCHEDULER or the OS scheduler.
Deliverables
• PL/SQL package (or equivalent) that performs the batch import
• Installation script to create the table if it doesn’t exist and to register the scheduler job
• Brief README or screencast showing how to change the source folder and rerun the load
Acceptance criteria
• PDFs load into APEX table in a single pass with filename, filesize, and timestamp recorded
• Rerunning the job skips or updates existing files without duplicates
• Any failure leaves the database in a consistent state and writes an error entry to a log table
If this lines up with your skills in Oracle APEX, PL/SQL, and file handling, I’m ready to review your approach and timeline.
Here’s what I picture: the job scans a nominated folder, ingests any new PDFs, stores them in the table, flags or archives the originals, and logs success or failure so I can audit the run. You’re free to choose the mechanics (UTL_FILE, DBMS_LOB, APEX_DATA_PARSER, SQL*Loader, or even a small Java/Python wrapper) as long as it plays nicely with APEX 22.1 and can be scheduled through DBMS_SCHEDULER or the OS scheduler.
Deliverables
• PL/SQL package (or equivalent) that performs the batch import
• Installation script to create the table if it doesn’t exist and to register the scheduler job
• Brief README or screencast showing how to change the source folder and rerun the load
Acceptance criteria
• PDFs load into APEX table in a single pass with filename, filesize, and timestamp recorded
• Rerunning the job skips or updates existing files without duplicates
• Any failure leaves the database in a consistent state and writes an error entry to a log table
If this lines up with your skills in Oracle APEX, PL/SQL, and file handling, I’m ready to review your approach and timeline.