Python cx_Oracle missing SELECT keyword

Question

I'm woking on Python cx_Oracle INSERT INTO and I'm having an error which I can't find

My code can successfully connect to Oracle server

My code is

curs = connect.cursor()
number1 = input("Input number = ")
name = input("Input name = ")
address = input("Input address")
date = input("Input date in DD-MON-YYYY format = ")
number2 = input("Input number = ")
statement = "INSERT INTO table (:number1,:name,:address,:date,:number2) VALUES (:x,:n,:a,to_date(:d, 'DD-MON-YYYY'),:y)"
curs.execute(statement,{'x':number1, 'n':name, 'a':address, 'd':date, 'y':number2})
curs.commit()

I have tried my inputs with

1234, John, Elm Street,01-JAN-2000, 5678

The error said

cx_Oracle.DatabaseError: ORA-00928: missing SELECT keyword

I'm guessing the error is probably from the date format but I can't quite find where the exact error lies in my code

Could someone please point out what I'm doing wrong?

Will you please give full traceback?

NPatel
– NPatel

2014-11-13 05:26:42 +00:00
Commented Nov 13, 2014 at 5:26 — NPatel
– NPatel, Commented Nov 13, 2014 at 5:26

Dan · Accepted Answer · 2014-11-26 18:55:34Z

2

'table' is a reserved word, so I'm not sure you can use as an actual table to query.

In your statement :number1 should be number1, :name should be name and so on.

answered Nov 26, 2014 at 18:55

Dan

10910 bronze badges

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

Collectives™ on Stack Overflow

Python cx_Oracle missing SELECT keyword

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related