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

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

Right...

I'm using cursor.execute(my_statement) to perform the update.  I am aware
that update statements aren't queries; however, I'm also aware that the
execute method is used to perform updates.  The script iterates through a
whole slew of update statements that work just fine before blowing up on
this one.



On Thu, Oct 7, 2010 at 10:28 AM, Anthony Tuininga <
ant...@gm...> wrote:

> Hi,
>
> Not sure exactly what you are trying to accomplish but showing the
> exact Python code you are executing would be helpful. In any case, the
> statement shown below is definitely not a query -- it looks very much
> like an update statement which does not query information but updates
> information in the database. So you should be simply doing this
>
> cursor.execute(your_statement)
>
> Do not attempt to fetch from the cursor, though. That will generate
> the "not a query" exception. Make sense?
>
> Anthony
>
> On Thu, Oct 7, 2010 at 8:29 AM, John Nielson <mr....@gm...>
> wrote:
> > 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
> >
> >
> ------------------------------------------------------------------------------
> > Beautiful is writing same markup. Internet Explorer 9 supports
> > standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> > Spend less time writing and  rewriting code and more time creating great
> > experiences on the web. Be a part of the beta today.
> > http://p.sf.net/sfu/beautyoftheweb
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
>
>
> ------------------------------------------------------------------------------
> Beautiful is writing same markup. Internet Explorer 9 supports
> standards for HTML5, CSS3, SVG 1.1,  ECMAScript5, and DOM L2 & L3.
> Spend less time writing and  rewriting code and more time creating great
> experiences on the web. Be a part of the beta today.
> http://p.sf.net/sfu/beautyoftheweb
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>



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