DPY-4009 when calling direct_path_load for inserting data when unspecified column has default value

[hkauffman]

1. What versions are you using?

Oracle DB: 19.28.0.0.0
python: 3.12.9
python-oracledb: 3.4.2

2. Is it an error or a hang or a crash?

Error

3. What error(s) or behavior you are seeing?

oracledb.exceptions.DatabaseError: DPY-4009: 2 positional bind values are required but 1 were provided

4. Does your application call init_oracle_client()?

No

5. Include a runnable Python script that shows the problem.

#!/usr/bin/env python3

import oracledb

conn = oracledb.connect()

rows = [
    (1,),
    (2,),
    (3,),
]

conn.direct_path_load(
    schema_name="test_schema",
    table_name="test_issue",
    column_names=["id"],
    data=rows
)

The code works as expected with this table definition:

create table test_issue(
  id number,
  test_date date
)

The code throws the error with this table definition:

create table test_issue(
  id number,
  test_date date default sysdate
)

If I explicitly include a test_date value in the rows it works in both cases.

[anthony-tuininga]

This is expected behavior. When using direct path loading, you must supply values for all columns. This is a requirement from the database!

[hkauffman]

I guess where I am confused is that it worsk with the default sysdate on it. It just leaves that column as null.

In sqlldr i could create a control file that would set the column to sysdate without having it in the source file and was trying to figure out an equivalent method.