]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Allow Oracle CLOB/NCLOB/BLOB in returning
authorMike Bayer <mike_mp@zzzcomputing.com>
Thu, 28 Jan 2021 16:04:29 +0000 (11:04 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Thu, 28 Jan 2021 21:38:21 +0000 (16:38 -0500)
commit893c4e7f89ae4018f286216e1cfc1b1b9341c939
treeed8edf6f3306d71150380889e6f0c7933d0f88c6
parentce81f016fbc599e5773a253e9c919ea90d192313
Allow Oracle CLOB/NCLOB/BLOB in returning

Fixed bug in Oracle dialect where retriving a CLOB/BLOB column via
:meth:`_dml.Insert.returning` would fail as the LOB value would need to be
read when returned; additionally, repaired support for retrieval of Unicode
values via RETURNING under Python 2.

As of yet, we still don't know how to reproduce the
ORA-24813 error indicated in the issue.

Also backporting the statement cache clear added to master
in f1e96cb087 , as we are testing in CI against two oracle
versions now there are sporadic failures that appear to be
memory related.

Fixes: #5812
Change-Id: I666f893e762dfa4d34dd2e324480565b226fb3a4
(cherry picked from commit 03179a96bfb9dd7ce17274fed44908c25229dedf)
doc/build/changelog/unreleased_13/5812.rst [new file with mode: 0644]
lib/sqlalchemy/dialects/oracle/cx_oracle.py
lib/sqlalchemy/dialects/oracle/provision.py
test/dialect/oracle/test_types.py