inserting data into oracle db using python

[sahilsiddharth]

my question here

my code here

I am unable to insert date into table by using variable in python 3.6.1. 
If i pass the value hard-coded, it is working, but the same is not working if i give it a variable name.

Below line of code is working :
**cursor.execute("INSERT INTO telm  VALUES('rahul')")**

But if i pass as variable :
*cursor.execute("INSERT INTO telm  VALUES(fname)")...giving error ORA-00984: column not allowed here*

[Larz60+]

show more context, preferably a piece of code that should run (even if not)
don't know why you are using *cursor.execute

[sahilsiddharth]

import sys
import cx_Oracle

class Customer():    
   def createCustomer(self,fname):
       print ("name is %s" % fname)
       db = cx_Oracle.connect('system/12345678@localhost/XE' )
       cursor=db.cursor()
       cursor.execute("INSERT INTO telm  VALUES (fname)")
       db.commit()

fname=input("Enter your first name :")
c1=Customer();
c1.createCustomer(fname)

     

output---

Output:
Enter your first name :rahul
name is rahul
Traceback (most recent call last):
 File "E:\python\test_cust.py", line 14, in <module>
   c1.createCustomer(fname)
 File "E:\python\test_cust.py", line 9, in createCustomer
   cursor.execute("INSERT INTO telm  VALUES (fname)")
cx_Oracle.DatabaseError: ORA-00984: column not allowed here

[Ofnuts]

import sys
import cx_Oracle

class Customer():    
   def createCustomer(self,fname):
       print ("name is %s" % fname)
       db = cx_Oracle.connect('system/12345678@localhost/XE' )
       cursor=db.cursor()
       cursor.execute("INSERT INTO telm  VALUES (fname)")
       db.commit()

fname=input("Enter your first name :")
c1=Customer();
c1.createCustomer(fname)
     

output---

Enter your first name :rahul
name is rahul
Traceback (most recent call last):
 File "E:\python\test_cust.py", line 14, in <module>
   c1.createCustomer(fname)
 File "E:\python\test_cust.py", line 9, in createCustomer
   cursor.execute("INSERT INTO telm  VALUES (fname)")
cx_Oracle.DatabaseError: ORA-00984: column not allowed here

See the "Bind Variable Patterns" section in this page.

[sahilsiddharth]

same error

[jogl]

This kind of thing works for me:

               with conn2:
                        cur2=conn2.cursor()
                        cur2.execute("""INSERT INTO boiltbl VALUES(%s,%s,%s,%s,%s,%s,%s)""", (time_now2,
                                                reply_s[4],reply_s[5],reply_s[2],reply_s[3],reply_s[0],reply_s[11]))
                        conn2.commit()

[sahilsiddharth]

now getting below error :

Error:
Enter your first name :ss
name is ss
Traceback (most recent call last):
 File "E:\python\test_cust.py", line 14, in <module>
   c1.createCustomer(a)
 File "E:\python\test_cust.py", line 9, in createCustomer
   cursor.execute("""INSERT INTO TELM VALUES(%s)""", (a))
cx_Oracle.DatabaseError: ORA-01036: illegal variable name/number

[jogl]

Check on the %s placeholder.  You may need to use a different letter there.

[Ofnuts]

same error

Please show the new code.

[nilamo]

cursor.execute("""INSERT INTO TELM VALUES(%s)""", (a))

That's not a tuple, it's just a. Because it's a single item, you need to add a comma to force a single-element tuple, like so:

cursor.execute("""insert into telm values (%s)""", (a, ))