Windows: Access Violation when calling executemany() · Issue #217 · oracle/python-oracledb (original) (raw)

@deymundson

  1. What versions are you using?
    Database Version: 19.14.0.0.0

platform.platform: Windows-10-10.0.19045-SP0
sys.maxsize > 2**32: True
platform.python_version: 3.11.4
oracledb.version: 1.4.0

  1. Is it an error or a hang or a crash?
    Crash
  2. What error(s) or behavior you are seeing?
    The python program immediately exits. The last exit code is -1073741819, which seems to indicate some form of access violation.
> .\python.exe
Python 3.11.4 (tags/v3.11.4:d2340ef, Jun  7 2023, 05:45:37) [MSC v.1934 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import oracledb
>>> oracledb.init_oracle_client()
>>> connection = oracledb.connect([REDACTED] ;P)
>>> cursor = connection.cursor()
>>> cursor.setinputsizes(None, int)
[None, <oracledb.Var of type DB_TYPE_NUMBER with value None>]
>>> cursor.executemany("select :1, :2 from dual", [])
[[Program immediately exits]]
> $LASTEXITCODE
-1073741819
  1. Does your application call init_oracle_client()?
    Yes
  2. Include a runnable Python script that shows the problem.

import oracledb oracledb.init_oracle_client() connection = oracledb.connect(...) cursor = connection.cursor() cursor.setinputsizes(None, int) cursor.executemany("select :1, :2 from dual", [])