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

[Chris D. <cdu...@ya...>]

Hi,

I've given it a try and my simple test case now works, thanks. However in my actual application I
now get an ORA-12704 Character set mismatch error. I need to investigate this one further to see
exactly what's going on.

Also with 4.2 I now get lots of Primary key violations on inserts after doing cursor.fetchraw()
and then inseting the results. The code works fine and as expected with 4.1.2. I'll need to some
more digging at my end on this as well but it does seem strange to get such different behaviour
changing from 4.1.2 to 4.2.

Thanks again,

Chris

--- Anthony Tuininga <ant...@gm...> wrote:

> 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
> > >
> >
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com