[sqlalchemy] Re: 0.4.0beta5 breaks [Oracle] query, works on 0.3.7 and with cxOracle - m h - com.googlegroups.sqlalchemy

21 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: 0.4.0beta5 breaks [O...

From	Sent On	Attachments
m h	21 Sep 2007 09:30
m h	21 Sep 2007 10:42
Michael Bayer	22 Sep 2007 08:18
m h	22 Sep 2007 08:49
Michael Bayer	22 Sep 2007 11:08
m h	22 Sep 2007 12:11
m h	22 Sep 2007 12:45
Michael Bayer	22 Sep 2007 13:30
m h	22 Sep 2007 13:38
m h	22 Sep 2007 21:05
m h	22 Sep 2007 22:00
m h	22 Sep 2007 22:15
m h	24 Sep 2007 16:22
Michael Bayer	24 Sep 2007 17:21
m h	24 Sep 2007 20:36
Michael Bayer	25 Sep 2007 05:45
m h	25 Sep 2007 11:04
Michael Bayer	25 Sep 2007 13:30
m h	25 Sep 2007 16:30
Michael Bayer	26 Sep 2007 06:54
m h	26 Sep 2007 08:30

Subject:	[sqlalchemy] Re: 0.4.0beta5 breaks [Oracle] query, works on 0.3.7 and with cxOracle
From:	m h (sesq...@gmail.com)
Date:	09/26/2007 08:30:16 AM
List:	com.googlegroups.sqlalchemy

On 9/26/07, Michael Bayer <mike...@zzzcomputing.com> wrote:

On Sep 25, 2007, at 7:30 PM, m h wrote:

Have updated the ticket with my fix.... change the dbapi_type of OracleText from CLOB to NUMBER.... I'm not sure if this breaks others code

the bug is, the type of the bind parameters should be coming out as VARCHAR, not CLOB. NUMBER is definitely wrong.

perchance, is the type of the column cal_dim.c.adwkenddt a CLOB ? (i.e. String with no length?) you didnt put the table on the ticket so i actually cannot test it (its an incomplete test case). just add a length and the whole thing should work.

Nope, not a CLOB, it's a DATE field.