Re: [cx-oracle-users] ORA -24806 error reading NCLOB data

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

Ok, I've had a chance to look at this and the reason the problem is
occurring is because Oracle wants SQLCS_NCHAR set as the character set
form and does not do so automatically. I've modified cx_Oracle to do
this as needed. There may be additional work that is needed (and I've
added infrastructure to support it) but my initial attempts to bind
NCLOB data appear to work just fine. After this is released (hopefully
very soon) you can check it out and let me know if more work is
needed.

On 6/9/06, Anthony Tuininga <ant...@gm...> wrote:
> Unfortunately, none at the moment. But I'll take a look at it at some
> point soon and let you know if I find anything. If anyone else has any
> information I'd love to hear about it. My knowledge of Unicode is not
> all that extensive. :-)
>
> On 6/9/06, Chris Dunscombe <cdu...@ya...> wrote:
> > I'm trying to read data from an NCLOB column using:
> >
> > for nclob_col, other_col in cursor.__iter__():
> >     nclob = nclob_col.read()
> >     ......
> >
> > This returns the Oracle error ORA-24806 - Lob form mismatch.
> >
> > Environment is:
> >   cx_Oracle version 4.1.2
> >   Oracle version 9.2.0.7
> >   Python 2.3.3
> >   SuSE Linux 8.2
> >
> > Anyone any ideas?
> >
> > Thanks,
> >
> > Chris Dunscombe
> >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
> >
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>