[Zope-DB] DCOracle2 Release 1.2 with Python-2.1.3, lobLocator.read() returns everytime None

Johannes Heinz j.heinz at sz-sb.de
Wed Jun 23 09:47:19 EDT 2004


I have a  MY_SCHEMA.DOK in Oracle 9i with 2 columns:
MY_ID (VarChar2) and MY_CLOB (CLOB)

MY_CLOB contains the text "test-lobcontents"
(tested with stored procedure in Oracle)

I did run the following instructions in Python (Python-2.3.3 with
DCOracle2 source-build)

>>> db=DCOracle2.connect(<connect-string>)
>>> cursor=db.cursor()
>>> cursor.execute("select MY_CLOB from MY_SCHEMA.DOK where MY_ID='1'")
>>> result=cursor.fetchone()
>>> myLobLocator=result[0]
>>> print myLobLocator.length() #returns correctly "16"
>>> print myLobLocator.read() #this allthough returns everytime NONE

Is this a bug or do I have to change the instructions to work around
this problem?

I hope, that someone has an idea!

Johannes Heinz

More information about the Zope-DB mailing list