I have no problems with other applications as long as I stick with floats. Notably, Zope on Windows running through ODBC has no problems--the values are all converted to python L types. (Hey! maybe I should take a look at the ODBC code...) This is what originally led me to believe that the problem wasn't with Oracle, but within the OCI interface to Zope. I also thought that it also might have something to do with my Linux install, but SQL*Net doesn't have problems and Zope works wonderfully except for long numbers. Environment info: Zope 1.10.2 ZOracleDA 2.0.0 RedHat Linux 5.2 Oracle Net8 Client Apache

-----Original Message----- From: Jordan B. Baker [SMTP:jbb@spyderlab.com] Sent: Tuesday, March 23, 1999 1:22 PM To: TFE MMS JARVIS JOHN Cc: zope@zope.org Subject: Re: [Zope] ZOracleDA and long numbers

On Tue, 23 Mar 1999, TFE MMS JARVIS JOHN wrote:

...

Hi all!

I'm having a problem with running queries containing long numbers. I found in db.py that the data type NUMBER is converted to an integer which overflows in my case.

The errors:

Error, oci.error: (1455, 'ORA-01455: converting column overflows integer datatype\012')

Without having yet looked at the source(*) could this be an error occuring in Oracle itself?

I just noticed the ORA-* which is typically an Oracle error message.

------- Jordan B. Baker -- jbb@spyderlab.com weaving the web @ http://www.spyderlab.com (*) - BEWARE :)