Can't set CLOB value in newobject

[hyperchair]

Hello,
I'm trying to enqueue a message and have SystemError on trying to set object CLOB field.
Type was created smth like that:
create or replace TYPE "TYPE_NAME" as object(MY_VALUE CLOB)

Python 3.7.1 (default, Oct 24 2018, 22:38:59)
[GCC 6.3.0 20170516] on linux
Running in python:3.7-slim docker (debian:stretch-slim 3.10.0-693.21.1.el7.x86_64)
Instant Client and cx_Oracle:

RUN apt update
RUN apt install -y unzip libaio1 git gcc
ADD instantclient-basic-linux.x64-18.5.0.0.0dbru.zip .
RUN mkdir oracle
RUN unzip instantclient-basic-linux.x64-18.5.0.0.0dbru.zip -d ./oracle
RUN echo "/opt/oracle/instantclient_18_5" > /etc/ld.so.conf.d/oracle.conf
RUN ldconfig

RUN git clone https://github.com/oracle/python-cx_Oracle.git cx_Oracle
WORKDIR /opt/cx_Oracle
RUN git submodule init
RUN git submodule update
RUN python setup.py install

Oracle Database version

>>> conn.version
'12.1.0.2.0'

import cx_Oracle
dsn_tns = cx_Oracle.makedsn(HOST, PORT service_name=SERVICE)
conn = cx_Oracle.connect(user=USER, password=PASSWORD, dsn=dsn_tns)
cursor = conn.cursor()
obj_type = conn.gettype('SCHEMA.TYPE_NAME')
new_obj = obj_type.newobject()
new_obj.MY_VALUE = 'testing'
# SystemError: error return without exception set

[anthony-tuininga]

Thanks. I can replicate the issue. I'll get back to you on the source of the issue.

[anthony-tuininga]

So, the bug is that it doesn't set an exception while returning an error. But once that was resolved it became clear that it was never supported! So I've made this an enhancement request as well -- and I have implemented it but I need to do a bit more testing yet before I publish it.

In the meantime, you can use a temporary LOB and assign that, like this:

lob = conn.createlob(cx_Oracle.CLOB)
lob.write("testing")
new_obj.MY_VALUE = lob

Once this enhancement lands you can do what you were doing and those steps are carried out behind the scenes.

[anthony-tuininga]

I've pushed the changes to correct the bug as well as implement the enhancement. If you are able to test for yourself, please do so and let me know how it works for you. Thanks!

[hyperchair]

Looks like everything is fine now. Thanks!

[anthony-tuininga]

This has been released with cx_Oracle 7.2.