[Zope-dev] Re: DCOracle not handling Oracle LONG/LONG RAW datatype

Andreas Jung ajung@sz-sb.de
Tue, 13 Jul 1999 09:24:59 +0200


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