Cx_Oracle. using to_date in python

Question

I want to insert a row into my table, but I am getting an error. Where am I going wrong?

CREATE TABLE  person (

  name          VARCHAR(40),
  birthday      DATE,
  PRIMARY KEY (name)
  );

Now in python I try to insert a person with the following statement...

     curs = connection.cursor

     name = input("Name: ")
     birthday = input("Birthdate(yyyy-mm-dd): ")

     insert = """insert into people(name, birthday) values (:name,:birthday)"""

     curs.execute(insert,{'name':name,'to_date(birthday, "yyyy-mm-dd")':birthday})

I get the following error:

curs.execute(insert,{'name':name,'to_date(birthday, "yyyy-mm-dd")':birthday})
cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number

CloudN9ne · Accepted Answer · 2014-03-20 07:23:32Z

2

Figured it out, I was inserting the date wrong. My syntax was incorrect and should have been:

 curs = connection.cursor

 name = input("Name: ")
 birthday = input("Birthdate(yyyy-mm-dd): ")

 insert = """insert into people(name, birthday) values (:name, to_date(:birthday, 'yyyy-mm-dd'))"""

 curs.execute(insert,{'name':name, 'birthday':birthday})

edited Mar 20, 2014 at 7:23

answered Mar 18, 2014 at 3:34

CloudN9ne

2351 gold badge3 silver badges8 bronze badges

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

Collectives™ on Stack Overflow

Cx_Oracle. using to_date in python

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