Python Oracle, inserting None error

Question

I'm getting an error when inserting None values into oracle in the following way:

    host = ('value1', 'value2', None, None)
    sql_insert = "INSERT INTO sm9_data_hostname (field1, field2, field3, field4) VALUES ( :1, :2, :3, :4)"
    conn_link.execute(sql_insert, host)
    connection.commit()

The error is: cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number

The insert works if I use 'Null' instead of None. I can't see what's wrong with this query as the parameters should replace the none with a Null. Or is this the wrong assumption?

Thanks, Isaac

Have you attempted using named placeholders? e.g. :field1, and passing as a dictionary? — donkopotamus
– donkopotamus, Commented Oct 12, 2015 at 11:53

donkopotamus · Accepted Answer · 2015-10-13 22:52:59Z

2

I have no experience at all with cx_Oracle but I would suggest you try using named placeholders as an alternative. Such as the following

conn_link.execute(
    "INSERT INTO sm9_data_hostname (field1, field2, field3, field4) "
    "VALUES (:field1, :field2, :field3, :field4)",
    dict(field1="value1", field2="value2", field3=None, field4=None)
)

answered Oct 13, 2015 at 22:52

donkopotamus

23.4k3 gold badges58 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python Oracle, inserting None error

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related