Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update Oracle 11 g - cx_Oracle

3172122Apr 16 2016 — edited Apr 16 2016

I have a problem with the update process of Orace DB (with Python), with this code:

cur = con.cursor()

query = "UPDATE finmodel.stock SET payout = :var1 WHERE Code = :var2"

cur.execute(query, {'var1': Payout, 'var2': ArrayCode[z]})

(payout is a number, arrayCode[z] is a string)

the program works well (no error) but the updating of the DB doesn't work...

I have tried to run the same SQL statement inside the DB Oracle (SQL environment of 11g Oracle) and the query works perfectly, then it is correct...(obviously I have change :var1 and :var2 with the variable value)

Where is the error?

Thanks!

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 14 2016
Added on Apr 16 2016
#python
1 comment
1,323 views