Mailing List Archive

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)
-------------------------------------------------------------------------------