So I am trying the new oracledb python library, which replaces cx\_oracle - as I dont want to have to install the oracle instant client.

```
un             = 'fred'
pwd            = 'mypass'
host           = 'server.mycompany.net'
port           =  1521
service_name   = 'servicea'

params = oracledb.ConnectParams(host=host, port=port, service_name=service_name)

with oracledb.connect(user=un, 
                      password=pwd,
                      params = params
                      ) as connection:

    with connection.cursor() as cursor:
        sql = "select * from dim_drug_product"
        for r in cursor.execute(sql):
            print(r)

```

And I just get this back:

> 
> File
> C:\ProgramData\Anaconda3\envs\ariel\lib\site-packages\oracledb\errors.py:103,
> in \_raise\_err(error\_num, context\_error\_message, cause, \*\*args)
> 101 message = f"{message}\n{context\_error\_message}"
> 102 exc\_type = ERR\_EXCEPTION\_TYPES[error\_num // 1000]
> --> 103 raise exc\_type(\_Error(message)) from cause
> 
> 
> NotSupportedError: DPY-3012: national character set id 871 is not
> supported by python-oracledb in thin mode
> 
> 
>