Cannot set NULL on DbObject attribute any more in 2.0 #273
Description
In 2.0 it is no longer possible to set an attribute on DbObject to NULL for a VARCHAR2.
This was possible in all previous versions of oracledb as well as cx_Oracle.
This bug was caused by the following change:
The change assumes that the value is not null.
There needs to be a condition that checks if it is null and then avoids performing this max size check, for example:
if value is not None and max_size > 0: if isinstance(value, str): actual_size[0] = len((<str> value).encode()) else: actual_size[0] = len(<bytes> value) if actual_size[0] > max_size: violated[0] = True - What versions are you using?
2.0
Give your database version.
19C
Also run Python and show the output of:
>>> import sys >>> import platform >>> >>> print("platform.platform:", platform.platform()) platform.platform: Linux-4.18.0-372.76.1.el8_6.x86_64-x86_64-with-glibc2.28 >>> print("sys.maxsize > 2**32:", sys.maxsize > 2**32) sys.maxsize > 2**32: True >>> print("platform.python_version:", platform.python_version()) platform.python_version: 3.12.1 And:
>>> import oracledb >>> print("oracledb.__version__:", oracledb.__version__) oracledb.__version__: 2.0.0 - Is it an error or a hang or a crash?
error
- What error(s) or behavior you are seeing?
Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/opt/app-root/lib/python3.12/site-packages/oracledb/dbobject.py", line 60, in __setattr__ self._impl.set_attr_value(attr_impl, value) File "src/oracledb/impl/base/dbobject.pyx", line 123, in oracledb.base_impl.BaseDbObjectImpl.set_attr_value File "src/oracledb/impl/base/dbobject.pyx", line 44, in oracledb.base_impl.BaseDbObjectImpl._check_max_size TypeError: object of type 'NoneType' has no len() Cut and paste text showing the command you ran. No screenshots.
Here is the PLSQL to create the record:
create or replace package foo_pkg is type r_bar IS RECORD (baz varchar2(10)); end foo_pkg; / create or replace package body foo_pkg is end foo_pkg; / Here is the python that creates an instance of the record type and set BAZ to null:
r_foo_type = conn.gettype('MY_SCHEMA.FOO_PKG.R_BAR') r_foo = r_foo_type.newobject() # This is OK, as expected r_foo.BAZ = 'hi' # Setting to NULL results in an error: r_foo.BAZ = None Here is the error:
Traceback (most recent call last): File "<stdin>", line 1, in <module> File "/opt/app-root/lib/python3.12/site-packages/oracledb/dbobject.py", line 60, in __setattr__ self._impl.set_attr_value(attr_impl, value) File "src/oracledb/impl/base/dbobject.pyx", line 123, in oracledb.base_impl.BaseDbObjectImpl.set_attr_value File "src/oracledb/impl/base/dbobject.pyx", line 44, in oracledb.base_impl.BaseDbObjectImpl._check_max_size TypeError: object of type 'NoneType' has no len() - Does your application call init_oracle_client()?
Yes, thick mode.
This tells us whether you are using the python-oracledb Thin or Thick mode.