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

[W. C. T. <cra...@gm...>]

Anthony ...

Thanks for the quick response.

Irritating (but not surprising) that Oracle is ignoring you -- Oracle
suffers from Not Invented Here syndrome.

In any case, thanks for all of the work putting together cx_Oracle.

- Craig -

On Wed, Sep 22, 2010 at 17:36, Anthony Tuininga
<ant...@gm...>wrote:

> 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 -
>