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
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:
Oracle Database version