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

[Anurag C. <anu...@gm...>]

Actually, upon reading the link sent by Andres further, I could make it to
work by changing

cursor.execute(query)
to
cursor.execute(str(query))

Regards,
Anurag

On Tue, Oct 25, 2011 at 12:40 AM, Anurag Chourasia <
anu...@gm...> wrote:

> Thanks for the response Andreas but I am already passing string type
> objects in the substitution variables.
>
> This is really strange as this was working fine before and works fine from
> most places..
>
>
> On Tue, Oct 25, 2011 at 12:30 AM, Andreas Mock <and...@we...>wrote:
>
>> Hi Anurag,****
>>
>> ** **
>>
>> searching for your error message with google brought this****
>>
>> as one of the top results. Probably it helps:****
>>
>> http://www.velocityreviews.com/forums/t691384-problem-about-cx_oracle.html
>> ****
>>
>> ** **
>>
>> Best regards****
>>
>> Andreas Mock****
>>
>> ** **
>>
>> ** **
>>
>> *From:* Anurag Chourasia [mailto:anu...@gm...]
>> *Sent:* Monday, October 24, 2011 8:39 PM
>> *To:* cx-...@li...; lar...@gm...
>> *Subject:* Re: [cx-oracle-users] expecting None or a string****
>>
>> ** **
>>
>> The print returns this****
>>
>> ** **
>>
>> SELECT count(*) FROM T WHERE NBR = '1' and ID='1'****
>>
>> ** **
>>
>> Both NBR and ID are varchar in my case.****
>>
>> ** **
>>
>> This query works fine when executed directly using Oracle PL/SQL Plus****
>>
>> ** **
>>
>> Regards,****
>>
>> Anurag****
>>
>> ** **
>>
>> On Tue, Oct 25, 2011 at 12:05 AM, Larry Martell <lar...@gm...>
>> wrote:****
>>
>> 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.
>>
>>
>> ------------------------------------------------------------------------------
>> The demand for IT networking professionals continues to grow, and the
>> demand for specialized networking skills is growing even more rapidly.
>> Take a complimentary Learning@Cisco Self-Assessment and learn
>> about Cisco certifications, training, and career opportunities.
>> http://p.sf.net/sfu/cisco-dev2dev
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users****
>>
>> ** **
>>
>>
>> ------------------------------------------------------------------------------
>> The demand for IT networking professionals continues to grow, and the
>> demand for specialized networking skills is growing even more rapidly.
>> Take a complimentary Learning@Cisco Self-Assessment and learn
>> about Cisco certifications, training, and career opportunities.
>> http://p.sf.net/sfu/cisco-dev2dev
>> _______________________________________________
>> cx-oracle-users mailing list
>> cx-...@li...
>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>
>>
>