I am definately encoutering similar problems, with both updates and selects using ZOracleDA with a LONG. I need to save around 100K of HTML to a LONG in Oracle, but updates fail with the message "identifier too long" and selects fail with the message "IndexError: 1". Oddly enough, if I write a simple testing stub (~1K) both the update and select work fine. Both the table layout and ZSQL code are simplistic. The table only has one LONG, and the ZSQL method attempts to select * and update using "sqlvar" (type=string). Any ideas what might be happening? (Linux Redhat 6; Zope 1.10.3; ZORACLEDA 2.2.0; Oracle 8) Cheers, Paul <19990713092458.a513-@sz-sb.de> wrote: original article:http://www.egroups.com/group/zope/?start=7724
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/ociCu rs.py", line 351, in fetchall v=f(1) File "/ojs/home/ojs/tools/python-1.5.2/lib/python1.5/DCOracle/ociCu rs.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)