Re: [sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread jr
That worked perfectly, thank you so much for your help! On Tuesday, October 1, 2019 at 3:35:25 PM UTC+2, Mike Bayer wrote: > > Hi there - > > you can use sqlalchemy.dialects.oracle.NUMBER directly: > > from sqlalchemy import Column > from sqlalchemy import MetaData > from sqlalchemy import Table >

Re: [sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread Mike Bayer
Hi there - you can use sqlalchemy.dialects.oracle.NUMBER directly: from sqlalchemy import Column from sqlalchemy import MetaData from sqlalchemy import Table from sqlalchemy.dialects import oracle from sqlalchemy.dialects.oracle import NUMBER from sqlalchemy.schema import CreateTable t = Table(

[sqlalchemy] Numeric type without scale? Oracle

2019-10-01 Thread jr
When the sqlalchemy Numeric type is used with default parameters, in an Oracle DB this generates the NUMBER type with empty precision but scale set to zero, which has the effect that only integer values can be saved. My goal is to use the Oracle NUMBER type with empty scale in order to sav