Re: [cx-oracle-users] Problem with cx_Oracle 5.0.4 and Unicode support for Oracle 10g

[Anthony T. <ant...@gm...>]

Hi,

I can see that problem myself in certain situations as well -- not
sure what the problem is but I suspect a bug in Oracle on certain
platforms. I have asked Oracle about it but have not received any
information to date. Based on other bugs that I have seen and some
other comments made on and off the list I am thinking that Unicode
mode is not worth the trouble and I am thinking of ripping it out
completely. In the meantime, so long as you can live without metadata
in unicode the normal mode works fine with unicode data passed in to
queries. If you want unicode returned, you can use a output type
converter method -- see the samples for an example. Hope that helps.

Anthony

On Wed, Sep 22, 2010 at 2:58 PM, W. Craig Trader <cra...@gm...> wrote:
> Additional information:
>
> When I look at the error context of the exception, the message is:
>
> in NumberVar_GetValue(): as string
>
> Which implies that the failure is in the call to OCINumberToText() at line
> 535 of NumberVar.c.
>
> - Craig -
>
> On Wed, Sep 22, 2010 at 14:15, W. Craig Trader <cra...@gm...>
> wrote:
>>
>> I'm trying to use cx_Oracle 5.0.4 on 64-bit RedHat EL 5.5 / CentOS 5.5)
>> with Python 2.6 and Oracle 10g (client libraries 10.2.0).
>>
>> When I build cx_Oracle without Unicode support, it all works as expected.
>> When I build cx_Oracle *with* Unicode support, attempting to use a query
>> that returns a numeric value (such as):
>>
>> con = Connection( ... )
>> cur = con.cursor()
>> cur.execute( 'SELECT 1 FROM DUAL' )
>> rows = cur.fetchall()
>>
>>  results in this exception:
>>
>> cx_Oracle.DatabaseError: OCI-22061: invalid format text [T
>>
>> I've tried the SourceForge RPMs and I've tried installing from the source
>> tar, and the results are consistent -- without Unicode works, with Unicode
>> fails.
>>
>> All help will be greatfully appreciated.
>>
>> - Craig -
>>
>
>
> ------------------------------------------------------------------------------
> Start uncovering the many advantages of virtual appliances
> and start using them to simplify application deployment and
> accelerate your shift to cloud computing.
> http://p.sf.net/sfu/novell-sfdev2dev
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>