Re: [cx-oracle-users] Missleading Error-Message within cx_Oracle unicode-build

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

Try sql = u"select 1 from dual"

On Wed, Oct 20, 2010 at 9:47 AM, Massa, Harald Armin <ch...@gh...> wrote:
> Hello,
> just transfering a project to cx_Oracle 5.0.4, Unicode built
> So sometimes I still have strings as sqls, trying to execute them give me a
> missleading errormessage:
> ocn = cx_Oracle.connect(...)
> ocs = ocn.cursor()
> sql = "select 1 from dual"
> ocs.execute(sql)
> raises a
> TypeError: expecting None or a string
> when, infact, "sql" IS a string, but cx_Oracle as an unicode build
> rightfully expects an unicode.
> I suggest to fix the type error,
> Harald
>
> --
> GHUM GmbH
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
>
> Amtsgericht Stuttgart, HRB 734971
> -
> persuadere.
> et programmare
>
> ------------------------------------------------------------------------------
> Nokia and AT&T present the 2010 Calling All Innovators-North America contest
> Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
> $10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
> Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
> http://p.sf.net/sfu/nokia-dev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>



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