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

[John N. <mr....@gm...>]

All:

I have a script that performs a bunch of updates.  However, after attempting
to perform the following query (carriage returns intentional):

update NIELSONJ.MYTABLE set COLUMN_1 = '"double quotes"
''single quotes''
En - dash
Em-dash
.       bullet
' where COLUMN_2 = -2395


I get the following error:

cx_Oracle.InterfaceError: not a query


I've copied and pasted the query into my IDE, executed it, and it runs just
fine.  It's definitely a query!  I am mystified.

Please note what kinds of quotes those are and that all single quotes within
the query are doubled to avoid terminating the update string.  The script is
intended to cleanse the database of data containing weird characters like
smart quotes (e.g. left single quotes are replaced with straight single
quotes).

-- 
John Nielson
mr....@gm...
(504) 344.7225