Re: [cx-oracle-users] expecting None or a string

[Larry M. <lar...@gm...>]

On Mon, Oct 24, 2011 at 12:31 PM, Anurag Chourasia
<anu...@gm...> wrote:
> Hi All,
> I am getting an error "expecting None or a string" when executing a simple
> SQL Query as this.
> query = "SELECT count(*) FROM T WHERE NBR = '%s' and ID='%s'" %(nbr,id)
> print query
> cursor.execute(query)
> This was working fine before and I have neither changed the code nor update
> cx_Oracle or Oracle version etc.

Well, what do you get when you print out the query? nrb or id probably
don't have the value you think.