I am on the following cx_Oracle version >>> cx_Oracle.version ‘5.0.3’ I am getting this exception in executing a query expecting None or a string The query is being executed this way, 8/31/2017 · So as you know I’m just in the middle here, my users have SQLAlchemy installed and so far we had it so that when they upgrade cx_Oracle from 5.x to 6, first due to #68 they’d lose precision, and now on a minor point release numeric support breaks entirely.. I can push out new SQLAlchemy’s but changing the setinputsizes behavior here, if I do that in older SQLAlchemy versions, now is that going …
9/20/2017 · Issue. c.executemany(None, [[1], [1.0]]) generates the exception TypeError: expecting integer because the first value is an integer, and the second one not. This worked fine with cx_Oracle 5.1 (and I think 5.2 too). I’m not sure if this is really a bug, please confirm.
3/2/2018 · But, I do have a cursor.setinputsizes that says that the expected column is a cx_Oracle.NATIVE_ FLOAT Questions: I cannot see in the documentation that cursor.setinputsizes is taken into account for executemany.
Re: [SPAM- bayes] Re: [cx -oracle- users] float vs. int Re: [SPAM- bayes] Re: [cx -oracle- users] float vs. int. From: Anthony Tuininga – 2003-10-06 19:36:25, SQL Queries¶. Queries (statements beginning with SELECT or WITH) can only be executed using the method Cursor.execute().Rows can then be iterated over, or can be fetched using one of the methods Cursor.fetchone(), Cursor.fetchmany() or Cursor.fetchall().There is a default type mapping to Python types that can be optionally overridden.
cx-oracle-users — Primary discussion list for users (and developers) of cx_Oracle … a float is returned. You can completely bypass this algorithm and do your own thing by using an outputtypehandler method. … It maybe that if you’re expecting the segment to exist after the create statement has run, but before you’ve added any data, this is …
That works but it does leave a bad taste in one’s mouth if one is expecting a more transparent solution. … cursor.somefunc(1, cx_Oracle.INTEGER) cursor.somefunc(2, cx_Oracle. FLOAT ) cursor.somefunc(3, cx_Oracle.FIXED_POINT) where of course, the constants defined above don’t exist yet and somefunc needs to be named properly so that it makes …
Hi everyone. I subscribed yesterday to the mailing list and I thought I might drop a line to say hi. First of all, my congrats to Anthony. cx_Oracle is a fine piece of work and the ultimate library when you want to combine oracle+python.
I would recommend using the Python types (str, int, float , decimal.Decimal, datetime.datetime) when calling setinputsizes() as the generic DB API types cover too much ground and the defaults may not work for you, especially for things like numbers ( cx_Oracle .NUMBER …
