Re: [cx-oracle-users] CLOBVar

[Harri P. <har...@tr...>]

On Thursday 18 November 2004 15:58, Anthony Tuininga wrote:
> Can you give me some code that demonstrates the problem? 4.1 beta 1
> deliberately adds support for pickling of LOB variables. Up until
> that release, you could not pickle LOB values -- you had to
> explicitly pickle str(lobValue) or something similiar. I'd be
> interested in tracking down this problem, though, since I'd like to
> release cx_Oracle 4.1 at some point and I'd hate to have to
> immediately release a patch for it! :-)

I just spent some time hunting it down:

It happened when pickling 'cursor.description', when the result set 
had a CLOB column.  It may well be that 3.1 version never hit CLOB 
type column before, and I had code to look out for other types of 
columns.

To reproduce, run:

import cx_Oracle, cPickle
cPickle.dumps(cx_Oracle.CLOB)

But as 

cPickle.dumps(cx_Oracle.NUMBER)

fails as well, I suppose it is not meant to work?

-Harri





This message, including any attachments, is intended only for the person(s) to whom it is addressed. If you received it in error, please let us know and delete the message from your system. This message may be confidential and may fall under the duty of non-disclosure. Any use by others than the intended addressee is prohibited. Trema shall not be liable for any damage related to the electronic transmission of this message, such as failure or delay of its delivery, interception or manipulation by third parties, or transmission of viruses or other malicious code.