Connecting to Oracle error with oracledb

[bnewman-tech]

What language are you using?

Python

What version are you using?

0.3.2 on a Macbook M1 Max Machine

What database are you using?

Oracle

What dataframe are you using?

Pandas and/or Polars

Can you describe your bug?

I am trying to use oracledb thin mode driver with connector-x without installing the Oracle Client. Is this possible and if so, what I am doing wrong?

Example query / code

import connectorx as cx

ENGINE_PATH = "oracle+oracledb://username:password@host:post/service_name"
query = "select * from table"  # query string

cx.read_sql(ENGINE_PATH, query)

What is the error?

[2023-11-01T02:17:30Z ERROR r2d2] DPI Error: DPI-1047: Cannot locate a 64-bit Oracle Client library:
"dlopen(libclntsh.dylib, 0x0001): tried: 'libclntsh.dylib' (no such file),
'/System/Volumes/Preboot/Cryptexes/OSlibclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib'
'(no such file, not in dyldcache), 'libclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib'
(no such file, not in dyld cache)". See https://oracle.github.io/odpi/doc/installation.html#macos for help

[johalnes]

I'm wondering about the same thing! Any progress?

[bnewman-tech]

Good morning,

I wanted to talk a moment to follow up on this and see if it is possible to use the thin driver https://oracle.github.io/python-oracledb/?