oracle/python-oracledb issues and pull requests

#537 - BIGINT from Oracle are truncated to 2147483647

Issue - State: closed - Opened by DATA2PLAYvf about 1 month ago - 6 comments
Labels: bug, patch available

#536 - Exporting large Arrow array crashes with cryptic error

Issue - State: closed - Opened by mauropagano about 2 months ago - 8 comments
Labels: bug, patch available

#535 - Support pyarrow.date32 ingest

Issue - State: closed - Opened by mauropagano 2 months ago - 10 comments
Labels: enhancement, patch available

#530 - Build failure due to strict cython == 3.1 pin in pyproject.toml (should this be ~=3.1 per PEP 440?)

Issue - State: closed - Opened by ryanwclark1 3 months ago - 2 comments
Labels: bug, patch available

#525 - Segfault when executing empty query

Issue - State: closed - Opened by doerwalter 3 months ago - 5 comments
Labels: bug, patch available

#512 - Create extras_require section for azure , oci depdendencies

Issue - State: closed - Opened by traylenator 4 months ago - 3 comments
Labels: enhancement, patch available

#510 - Fetch DF picks wrong datatype when expression is present

Issue - State: closed - Opened by mauropagano 4 months ago - 7 comments
Labels: bug, patch available

#508 - Thin mode fails on array insert with empty parameter set

Issue - State: closed - Opened by mauropagano 5 months ago - 2 comments
Labels: bug, patch available

#500 - ORA-22922 in async LOB reading from cursor

Issue - State: closed - Opened by klymenkosergiy 5 months ago - 10 comments
Labels: bug, patch available

#499 - Fetching DATE/TIMESTAMP as DF converts to UTC TZ

Issue - State: closed - Opened by mauropagano 6 months ago - 5 comments
Labels: bug, patch available

#494 - Support type casting in ODF

Issue - State: closed - Opened by mauropagano 6 months ago - 4 comments
Labels: enhancement, patch available

#493 - Unable to use python-oracledb with Cython 3.1.0

Issue - State: closed - Opened by anthony-tuininga 6 months ago - 4 comments
Labels: bug, patch available

#486 - Fetching DF segfaults when outputtypehandler is present

Issue - State: closed - Opened by mauropagano 7 months ago - 11 comments
Labels: bug, patch available

#476 - ORA-03115 on attempt to connect in Thin mode

Issue - State: closed - Opened by WolfEYc 8 months ago - 17 comments
Labels: bug, patch available

#472 - Execute hangs or throws unclear error on divide by zero situation

Issue - State: closed - Opened by ncollins-vs 8 months ago - 3 comments
Labels: bug, patch available

#470 - Cannot convert the same OracleDataFrame to a PyArrow table twice

Issue - State: closed - Opened by cpcloud 8 months ago - 5 comments
Labels: bug, patch available

#468 - CLOB in/out parameters no longer work in 3.0.0

Issue - State: closed - Opened by doerwalter 8 months ago - 4 comments
Labels: bug, patch available

#458 - fetch_lobs setter on Defaults has the wrong type

Issue - State: closed - Opened by srtucker 9 months ago - 2 comments
Labels: bug, patch available

#456 - Nested records - value not returned in specific cases

Issue - State: closed - Opened by pvapenka-cen69045 9 months ago - 5 comments
Labels: bug, patch available

#455 - Cryptography not installed

Issue - State: closed - Opened by HudecRoman 9 months ago - 9 comments
Labels: enhancement, patch available

#448 - async pool.acquire() not working in thick mode

Issue - State: closed - Opened by migelle74 10 months ago - 5 comments
Labels: bug, patch available

#441 - AsyncCursor cannot bind long string to clob parameter

Issue - State: closed - Opened by klymenkosergiy 10 months ago - 6 comments
Labels: bug, patch available

#438 - `connect` & `connect_async` typing

Issue - State: closed - Opened by cepedus 10 months ago - 9 comments
Labels: enhancement, patch available

#429 - JSONDecodeError on empty CLOB

Issue - State: closed - Opened by jpic 11 months ago - 9 comments
Labels: bug, patch available

#426 - Could thin pool graceful cleanup thread be instantiated not on module import?

Issue - State: closed - Opened by stephen-hansen 11 months ago - 6 comments
Labels: enhancement, patch available

#425 - thick mode : segmentation fault using connection pool and auto_login wallet

Issue - State: closed - Opened by gdraelan 11 months ago - 9 comments
Labels: bug, patch available

#424 - DPY-5000: internal error: unknown protocol message under very subtile conditions

Issue - State: closed - Opened by AntonOvsyannikov 12 months ago - 7 comments
Labels: bug, patch available

#420 - Retry count has no effect in thin mode when using an address list and running into a timeout

Issue - State: closed - Opened by quantuminternet 12 months ago - 3 comments
Labels: bug, patch available

#411 - Detect, undo, and forget setinputsizes() on cursor

Issue - State: closed - Opened by deonav about 1 year ago - 3 comments
Labels: enhancement, patch available

#408 - method connect hangs until driver is used in another thread

Issue - State: closed - Opened by dbacvetkov about 1 year ago - 11 comments
Labels: enhancement, patch available

#404 - ConnectionPool ignores connectiontype parameter with externalauth=False

Issue - State: closed - Opened by ancc about 1 year ago - 4 comments
Labels: bug, patch available

#397 - can't `gettype()` for a "table of records" type

Issue - State: closed - Opened by zea-vtl about 1 year ago - 6 comments
Labels: bug, patch available

#395 - Add max_identifier_length attribute to get connection

Issue - State: closed - Opened by CaselIT about 1 year ago - 36 comments
Labels: enhancement, patch available

#392 - Connections remain in busy connection list and can't be reused in pool

Issue - State: closed - Opened by golubovai about 1 year ago - 3 comments
Labels: bug, patch available

#391 - Proper type hint of Cursor.execute parameters

Issue - State: closed - Opened by rob975 about 1 year ago - 3 comments
Labels: bug, patch available

#385 - Unhelful error message when accessing connection attributes in subclass constructor

Issue - State: closed - Opened by doerwalter about 1 year ago - 6 comments
Labels: bug, patch available

#383 - Oracledb 2.4.0 connection error: DPY-3008: unsupported in-band notification with error number 12572

Issue - State: closed - Opened by ml-huber about 1 year ago - 11 comments
Labels: bug, patch available

#368 - Thin mode - Segmentation Fault when using oracledb.CURSOR

Issue - State: closed - Opened by mkmoisen over 1 year ago - 8 comments
Labels: bug, patch available

#362 - getting DPY-4000 in thin mode, add support for comma separated `net_service_name`s in tnsnames.ora

Issue - State: closed - Opened by izirku over 1 year ago - 5 comments
Labels: bug, patch available

#361 - Connection pool's timer thread don't stop on pool close

Issue - State: closed - Opened by golubovai over 1 year ago - 3 comments
Labels: bug, patch available

#360 - Var.outconverter() is not writable

Issue - State: closed - Opened by leo-b over 1 year ago - 3 comments
Labels: bug, patch available

#353 - Concurrent open of connections don't work on 2.2.0 and 2.2.1 also (operation takes forever)

Issue - State: closed - Opened by golubovai over 1 year ago - 7 comments
Labels: bug, patch available

#352 - DPY-4000 when using EZCONNECT syntax (which worked with 1.2.1)

Issue - State: closed - Opened by hvbtup over 1 year ago - 12 comments
Labels: bug, patch available

#346 - deqone() with JSON queue causes PGA memory leak in Oracle process PGA area in ILOC_KPDLOB

Issue - State: closed - Opened by christo4nextria over 1 year ago - 5 comments
Labels: bug, patch available

#343 - Question , Is any way to set V$Session module, Action , Clientinfo before connection cursor created

Issue - State: closed - Opened by koasi over 1 year ago - 7 comments
Labels: enhancement, patch available

#339 - Internal exception raised when DSN connection string is badly formatted

Issue - State: closed - Opened by nmoreaud over 1 year ago - 8 comments
Labels: bug, patch available

#338 - Connection sets itself in a corrupted state after receiving an exception

Issue - State: closed - Opened by Epithumia over 1 year ago - 3 comments
Labels: bug, patch available

#313 - Expose service names available in tnsnames.ora

Issue - State: closed - Opened by mac-vtl over 1 year ago - 5 comments
Labels: enhancement, patch available

#304 - callproc with a %ROWTYPE returns an error when Timestamp precedes a Varchar2

Issue - State: closed - Opened by RecycleBen over 1 year ago - 6 comments
Labels: bug, patch available

#288 - Async changes break connecting under certain circumstances

Issue - State: closed - Opened by jeamland almost 2 years ago - 3 comments
Labels: bug, patch available

#285 - Async database pool does not return connections

Issue - State: closed - Opened by felindev almost 2 years ago - 30 comments
Labels: bug, patch available

#279 - UnicodeDecodeError: 'utf-8' codec can't decode byte (outputtypehandler encoding_errors="replace" not being honored)

Issue - State: closed - Opened by anthony-tuininga almost 2 years ago - 2 comments
Labels: bug, patch available

#278 - identified a possible hang in async cursor.executemany()

Issue - State: closed - Opened by zzzeek almost 2 years ago - 12 comments
Labels: bug, patch available

#276 - Async support not compatible with alternative event loop implementations like `uvloop`

Issue - State: closed - Opened by citreae535 almost 2 years ago - 4 comments
Labels: bug, patch available

#275 - oracledb2 hangs when getting connection from pool

Issue - State: closed - Opened by ThiefMaster almost 2 years ago - 17 comments
Labels: bug, patch available

#273 - Cannot set NULL on DbObject attribute any more in 2.0

Issue - State: closed - Opened by mkmoisen almost 2 years ago - 3 comments
Labels: bug, patch available

#271 - cursor.execute() fails when fetching from table with NCLOB column and IS JSON check.

Issue - State: closed - Opened by felixxm almost 2 years ago - 11 comments
Labels: bug, patch available

#263 - Using DB_TYPE_BOOLEAN in SQL on Oracle 23c.

Issue - State: closed - Opened by felixxm almost 2 years ago - 4 comments
Labels: bug, patch available

#259 - Support for passing additional SSL cipher suites for TLS connections

Issue - State: closed - Opened by hvardhan20 almost 2 years ago - 3 comments
Labels: enhancement, patch available

#257 - Timezone autodetection in thin mode is wrong

Issue - State: closed - Opened by szpajder almost 2 years ago - 4 comments
Labels: bug, patch available

#255 - init_oracle_client lib dir with chinese

Issue - State: closed - Opened by 13033266796 almost 2 years ago - 13 comments
Labels: enhancement, install & configuration, patch available

#250 - No access to `proxy_user` once connection is made

Issue - State: closed - Opened by thrandale about 2 years ago - 3 comments
Labels: enhancement, patch available

#221 - Broken connections in pool become busy indefinitely

Issue - State: closed - Opened by 7opf about 2 years ago - 15 comments
Labels: bug, patch available

#217 - Windows: Access Violation when calling executemany()

Issue - State: closed - Opened by deymundson about 2 years ago - 3 comments
Labels: bug, patch available

#211 - ResourceWarning: unclosed socket when password is invalid

Issue - State: closed - Opened by petronny over 2 years ago - 2 comments
Labels: bug, patch available

#205 - cx_oracle allows me to insert pyodbc.row object or objects in executemany() and execute. oracledb does not!

Issue - State: closed - Opened by hl1 over 2 years ago - 5 comments
Labels: bug, patch available

#204 - oracledb stopped from being installed on alpine image due to new cython release

Issue - State: closed - Opened by emarques over 2 years ago - 11 comments
Labels: install & configuration, patch available

#178 - ORA-12162 when connecting to database since upgrade to 1.3.0

Issue - State: closed - Opened by glM26 over 2 years ago - 10 comments
Labels: bug, patch available

#176 - DPY-5000: internal error: unknown protocol message type 0 while connecting to oracleDB

Issue - State: closed - Opened by kartik1581 over 2 years ago - 10 comments
Labels: bug, patch available

#173 - Intermittent errors when using oracledb via DJango persistence - IndexError: list assignment index out of range

Issue - State: closed - Opened by unicman over 2 years ago - 11 comments
Labels: bug, patch available

#172 - Poor performance when running a large statement. sqlalchemy + oracledb

Issue - State: closed - Opened by kryvokhyzha over 2 years ago - 6 comments
Labels: question, patch available

#147 - `cursor.rowcount` is higher than the number of rows returned by `cursor.fetchall`

Issue - State: closed - Opened by agrvz over 2 years ago - 4 comments
Labels: bug, patch available

#146 - Insert bind variables with large string value

Issue - State: closed - Opened by chichur over 2 years ago - 4 comments
Labels: bug, patch available

#144 - thin mode: detect timezone

Issue - State: closed - Opened by BayerSe over 2 years ago - 4 comments
Labels: enhancement, patch available

#135 - Insert empty string into Database

Issue - State: closed - Opened by lihofm almost 3 years ago - 13 comments
Labels: bug, patch available

#133 - Multibyte string in query results in ORA-03120/ORA-03146 DatabaseError

Issue - State: closed - Opened by reuben-li almost 3 years ago - 17 comments
Labels: bug, patch available

#132 - Hang in Thin-mode using PL/SQL without setinputsizes()

Issue - State: closed - Opened by M4X1K02 almost 3 years ago - 3 comments
Labels: bug, patch available

#130 - When DNS name resolves to multiple IP addresses, driver attempts a connection to only one IP address (thin mode)

Issue - State: closed - Opened by ilmarkerm almost 3 years ago - 4 comments
Labels: bug, patch available

#128 - Using "batcherrors=True" raises a ORA-03137 exception

Issue - State: closed - Opened by M4X1K02 almost 3 years ago - 4 comments
Labels: bug, patch available

#125 - Thin client: query caching problem when new table columns are added

Issue - State: closed - Opened by myjniak almost 3 years ago - 4 comments
Labels: bug, patch available

#123 - Thin mode: connection.gettype error

Issue - State: closed - Opened by ivba7 almost 3 years ago - 3 comments
Labels: bug, patch available

#119 - Oracledb thin mode:: object of type 'bool' has no len()]

Issue - State: closed - Opened by ivba7 almost 3 years ago - 7 comments
Labels: bug, patch available

#114 - Bequeath connections are failing with ORA-12545

Issue - State: closed - Opened by theo-fokkinga almost 3 years ago - 4 comments
Labels: bug, patch available

#112 - pwd.getpwduid(os.getuid()) error on serverless workload

Issue - State: closed - Opened by arthurql almost 3 years ago - 2 comments
Labels: bug, patch available

#107 - outconverter doesn't work when the value is null

Issue - State: closed - Opened by lypch almost 3 years ago - 9 comments
Labels: enhancement, patch available

#105 - DPY-4008: Bind variable not found if between two comment blocks

Issue - State: closed - Opened by npodewitz almost 3 years ago - 3 comments
Labels: bug, patch available

#104 - bind out variable causes ORA-03146 when using "insert .... returning ..."

Issue - State: closed - Opened by JuanPDP11 almost 3 years ago - 12 comments
Labels: bug, patch available

#101 - Can not create a connection pool with a proxy user while this is possible in cx_Oracle.

Issue - State: closed - Opened by gpaulissen almost 3 years ago - 4 comments
Labels: bug, patch available

#99 - return object attributes as int if metadata says it can be expressed as int

Issue - State: closed - Opened by leo-b almost 3 years ago - 2 comments
Labels: enhancement, patch available

#81 - Need Support with connection string for CMAN connection to DB (Source_route=yes) in connection string

Issue - State: closed - Opened by sme-eprince about 3 years ago - 12 comments
Labels: enhancement, patch available

#65 - Improve TLS connection implementation to support use of one way TLS certificates without needing OS recognition

Issue - State: closed - Opened by FrancoisNoyez about 3 years ago - 20 comments
Labels: enhancement, patch available

#60 - Change return types to avoid IDE errors/warnings

Issue - State: closed - Opened by HPRIOR about 3 years ago - 1 comment
Labels: enhancement, patch available

#54 - Enhance type hinting in the subscr module

Issue - State: closed - Opened by troyswanson about 3 years ago - 2 comments
Labels: enhancement, patch available

#52 - ConnectionPool.acquire instance method returns type checking errors

Issue - State: closed - Opened by troyswanson about 3 years ago - 7 comments
Labels: bug, patch available

#51 - TypeError: cannot convert 'NoneType' object to bytearray when connecting to oracledb server 19.2 in thin mode

Issue - State: closed - Opened by abma about 3 years ago - 12 comments
Labels: bug, patch available

#44 - Fallback by thick mode

Issue - State: closed - Opened by sosoba over 3 years ago - 14 comments
Labels: enhancement, patch available

#43 - Add support for DB_TYPE_OBJECT in thin mode

Issue - State: closed - Opened by petronny over 3 years ago - 6 comments
Labels: enhancement, patch available

#41 - ORA-01008: not all variables bound - but they are bound

Issue - State: closed - Opened by lironshurgi over 3 years ago - 13 comments
Labels: bug, patch available

#39 - Thin via SCAN listener fails with DPY-6000 -- SERVICE_NAME not passed to local listener

Issue - State: closed - Opened by RMacG over 3 years ago - 7 comments
Labels: bug, patch available

#35 - Executemany uses first row as template for the following rows.

Issue - State: closed - Opened by TsunekiR over 3 years ago - 5 comments
Labels: bug, patch available

GitHub / oracle/python-oracledb issues and pull requests