INSERT not working in cx_oracle when used with execute. How to get it working?

python cx-oracle oracle11gr2
Khwaishien picture Khwaishien · Apr 13, 2011 · Viewed 11.4k times · Source

I am new to cx_oracle. I have established a connection and I am able to create and drop a table using execute.

Where I am failing is when I try to use "INSERT INTO ..." in execute. It doesn't show any error but it doesn't store any value either (I confirmed this by checking if the entry had taken place using sqlplus from shell). The code I used was:

table_name = "T1"
column = "D"
insert_value = "test value"

sqlcode = "INSERT INTO "+table_name+" ("+column+") VALUES ('"+insert_value+"')"
cursor.execute(sqlcode)

Please help me, any help would be appreciated.

Thanks in advance. J

Answer

Venu Murthy picture Venu Murthy · May 22, 2013

How can cursor.commit work when the methods in Cursor do not have commit, connections has this method and hence it should be:

    connection.commit()

Using cursor.commit() returns:
AttributeError: 'cx_Oracle.Cursor' object has no attribute 'commit'

Related questions

How can I access Oracle from Python?

How can I access Oracle from Python? I have downloaded a cx_Oracle msi installer, but Python can't import the library. I get the following error: import cx_Oracle Traceback (most recent call last): File "<pyshell#1>", line 1, in &…

Read More
cx_Oracle and Exception Handling - Good practices?

I'm trying to use cx_Oracle to connect to an Oracle instance and execute some DDL statements: db = None try: db = cx_Oracle.connect('username', 'password', 'hostname:port/SERVICENAME') #print(db.version) except cx_Oracle.DatabaseError as e: error, = e.…

Read More
Help installing cx_Oracle

I'm trying to install the cx_Oracle for Python 2.6, but it is failing. I don't know enough about C or MS Vis. Studio's compiler to even approach fixing it myself. This is what is output on the command line: C:\…

Read More