On Mon, Jul 12, 1999 at 09:23:20AM -0700, Larry Gwinn wrote:

Hello All,

I have been evaluating the DCOracle extension from http://www.zope.org/Download/DCOracle/ and have run into an issue when querying tables with a LONG or LONG RAW data type and I was wondering if anybody else has encountered this problem. If you execute a SQL select statement that retrieves from a column that is defined as a LONG or LONG RAW datatype, when you perform a fetchone you can only successfully retrieve the first row. The next fetchone will cause a "IndexError: 1" to occur. This exception is being thrown by the Buffer_item function located in the Buffer.c file.

I can confirm this behaviour. I always get the following traceback when I try to access a column of type LONG: Traceback (innermost last): File "./test.py", line 25, in ? data = ORA.curs.fetchall() File "/ojs/home/ojs/tools/python-1.5.2/lib/python1.5/DCOracle/ociCurs.py", line 351, in fetchall v=f(1) File "/ojs/home/ojs/tools/python-1.5.2/lib/python1.5/DCOracle/ociCurs.py", line 311, in fetchone if ind[ai] < 0: v=MissingValue IndexError: 1 Testing env: Solaris 2.6, Oracle 7.3.3.6, DCOracle 1.2.1, Python 1.5.2 Cheers, Andreas -- _\\|//_ (' O-O ') ------------------------------ooO-(_)-Ooo-------------------------------------- Andreas Jung, Saarbrücker Zeitung Verlag und Druckerei GmbH Saarbrücker Daten-Innovations-Center Gutenbergstr. 11-23, D-66103 Saarbrücken, Germany Phone: +49-(0)681-502-1563, Fax: +49-(0)681-502-1509 Email: ajung@sz-sb.de (PGP key available) -------------------------------------------------------------------------------