[Zope] ZOracleDA and long numbers

[TFE MMS JARVIS JOHN]

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