[Zope] ZOracleDA and long numbers

[Jim Fulton]

"Jordan B. Baker" wrote:
> 
> 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.

Right, but in this case, it's because DCOracle bound a buffer
that was too small to hold the values.

Jim

--
Jim Fulton           mailto:jim@digicool.com   Python Powered!        
Technical Director   (888) 344-4332            http://www.python.org  
Digital Creations    http://www.digicool.com   http://www.zope.org    

Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email
address may not be added to any commercial mail list with out my
permission.  Violation of my privacy with advertising or SPAM will
result in a suit for a MINIMUM of $500 damages/incident, $1500 for
repeats.