Re: [cx-oracle-users] cx_Oracle.InterfaceError: not a query

[Robert <web...@gm...>]

>>>>                 if update_flag:
>>>>                     #
>>>>                     # If an update is necessary, print row's PK value
>>>>                     print "\tChange needed for %s = %d" % (uid_col, uid)
>>>>                     update_query = "update " + full_name + " " + \
>>>>                                    "set " + column + \
>>>>                                    " = '" + returned_string + "' " +\
>>>>                                    "where " + uid_col + \
>>>>                                    " = " + str(uid)
>>>>                     cur.execute(query)
>>>>
>>>> conn.close()


personally I hate writing and reading string concat code like this.
I  would dump the SQLs to a file and read back in and execute in iteration.
I like viewing exactly what I send to Oracle.