SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upload pdf files into DB-table from local folder (not from DBTIER)

Olivier-HologicJun 22 2026

Systems/Programs used:

Windows 11
Oracle DB: 19.23.0
SQLcl: 25.4.2.044.1837

Goal: Load records into a DB-Table with physical pdf files from local machine.

Creating table

CREATE TABLE HOLX_BLOB_FILES_CONV (
    file_id NUMBER,
    file_name VARCHAR2(255),
    file_content BLOB
);

csv ciontent

FILE_ID,FILE_NAME,FILE_CONTENT
1,invoice1.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice1.pdf
2,invoice2.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice2.pdf
3,invoice3.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice3.pdf

Sqlcl commands running from a Window 11 machine (aka: local laptop).

SET LOADFORMAT csv COLUMNNAMES ON
SET LOAD MAPCOLUMNNAMES (FILE_ID=FILE_ID,FILE_NAME=FILE_NAME,FILE_CONTENT=FILE_CONTENT)

LOAD TABLE HOLX.HOLX_BLOB_FILES_CONV C:\Users\xxx\Downloads\LoadFiles\load_list.csv;

Result of the load command

csv
column_names on
delimiter ,
enclosures ""
double off
encoding UTF8
row_limit off
row_terminator default
skip_rows 0
skip_after_names

Load data into table HOLX.HOLX_BLOB_FILES_CONV
batch_rows 50
batches_per_commit 10
clean_names transform
column_size rounded
commit on
date_format
errors 50
map_column_names (FILE_CONTENT=FILE_CONTENT, FILE_ID=FILE_ID, FILE_NAME=FILE_NAME)
method insert
timestamp_format
timestamptz_format
locale English United States
scan_rows 100
truncate off
unknown_columns_fail on

#ERROR Insert failed in batch rows  1  through  3
#ERROR ORA-01465: invalid hex number

https://docs.oracle.com/error-help/db/ora-01465
#ERROR Row 1 data follows:
1,invoice1.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice1.pdf
#ERROR Row 2 data follows:
2,invoice2.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice2.pdf
#ERROR Row 3 data follows:
3,invoice3.pdf,C:\Users\xxx\Downloads\LoadFiles\invoice3.pdf
#INFO Number of rows processed: 3
#INFO Number of rows in error: 3
#INFO Last row processed in final committed batch: 3
WARNING: Processed with errors