- ANNOUNCE: DCOracle release
We have a release of DCOracle 1.1.0 available at: http://www.zope.org/Download/DCOracle/ This is a Python DBI-compliant extension module for Oracle. This package is *not* a Zope Database Adapter (which we are working on). All of you clever monkeys out there though can probably figure out pretty quickly how to convert another Database Adapter to use the DCOracle module, as one beta tester was able to do. --Paul Paul Everitt Digital Creations paul@digicool.com 540.371.6909
Paul, MAN!!! You guys are GREAT! Paul Everitt wrote:
We have a release of DCOracle 1.1.0 available at:
http://www.zope.org/Download/DCOracle/
This is a Python DBI-compliant extension module for Oracle. This package is *not* a Zope Database Adapter (which we are working on). All of you clever monkeys out there though can probably figure out pretty quickly how to convert another Database Adapter to use the DCOracle module, as one beta tester was able to do.
--Paul
Paul Everitt Digital Creations paul@digicool.com 540.371.6909
-- Cheers, --ldl ----------------------------------------------------------------------------- LD Landis ldl@HealthPartners.Com N0YRQ Voice 612/883-5511 Fax 612/883-6363 HealthPartners, 8100 34th Avenue So, PO Box 1309, Minneapolis, MN 55440-1309 Shape your life not from your memories, but from your hopes. (Borrowed) -----------------------------------------------------------------------------
Heya Paul, I'm coming up with a problem that I can't seem to figure out - was wondering if you or one of the other Zope-types out there could shed some light... I've got a table that includes this field: TIMESTAMP NOT NULL NUMBER(38) I'm trying to write a method to talk to it, as so: select * from unresolved_flows where timestamp > '<!--#sqlvar start_time type=float-->' and timestamp < '<!--#sqlvar end_time type=float-->' (This is simply the latest try - I've tried #var end_time fmt=sql-quote, and that doesn't seem to be any different). The error I'm getting back from ZOracleDA (well, from DCOracle, to be precise, through your ZOracleDA) is: Error, oci.error: (1455, 'ORA-01455: converting column overflows integer datatype\012') SQL used: select * from unresolved_flows where timestamp > '916324638' and timestamp < '916411017' I get the same thing, incidentally, when I import DCOracle, and run the query direct. I don't get the same thing if I import oracledb (Anthony Baxter's oracle module) and run that query. I'm baffled. Anyone spot an easy fix for this? KevinL
participants (3)
-
Kevin Littlejohn -
LD Landis -
Paul Everitt