search

oracle / python-cx_Oracle

Python interface to Oracle Database now superseded by python-oracledb
https://oracle.github.io/python-cx_Oracle
Other
889 stars 361 forks source link

Setting v$session.osuser like JDBC driver #588

Closed altairbow closed 3 years ago

altairbow commented 3 years ago

In JDBC driver we can set some connection properties regarding v$session (e.g. v$session.osuser). Is it available in this package?

cjbj commented 3 years ago

Sorry this isn't possible. This is dependent on the Oracle Client libraries which don't support that functionality.

I'd argue you shouldn't be changing the attributes, and should look at other ways to pass information from the app to the DB.

The request is noted. I'll close this issue since it's out of scope for cx_Oracle.

mxdev88 commented 3 years ago

I'd argue you shouldn't be changing the attributes, and should look at other ways to pass information from the app to the DB.

Looking for similar feature to set program and module (module is available but only once the connection is made. Would it be possible to pass as param?). What are the suggestions to pass information from the app to the DB?